UPDATE table1 SET table1.column = table2.column FROM Table1 table1 INNER JOIN Table2 table2 ON table1.id = table2.id;