T-Sql Update mit Inner Join
UPDATE dbo.Table2
SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB
FROM dbo.Table2
INNER JOIN dbo.Table1
ON (dbo.Table1.ColA = 'PARAM')
WHERE dbo.Table2.ColB < dbo.Table1.ColB
1
2
3
4
5
6
2
3
4
5
6