update ve select

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



________________________________