Ms Sql : Update From Select

[anselme]

Hi

how can you update many fields from a select ? :


UPDATE table1 (a1,b1,c1) SELECT (a2,b2,c2) FROM table2 WHERE table1.id = table2.id

for MS SQL 2000/25000

thank you for helping

[anselme]

if there is not a better method I think I got it :

UPDATE table1
SET a1=a2,b1=b2,c1=c2
FROM table1 INNER JOIN table2 WHERE table1.id = table2.id