Update data using 2 or more tables – T-SQL
Oct.15, 2009 in
Databases
It happens quite frequently that I need to update data using data from a different table… really useful…
UPDATE a
SET a.Col1 = b.Col1
FROM table1 a JOIN table2 b ON a.Col2 = b.Col2
WHERE <Conditions>
Leave a Reply