1UPDATE YourTable
2SET Col1 = OtherTable.Col1,
3 Col2 = OtherTable.Col2
4FROM (
5 SELECT ID, Col1, Col2
6 FROM other_table) AS OtherTable
7WHERE
8 OtherTable.ID = YourTable.ID
1
2 UPDATE table_name
3
4 SET column1 = value1, column2 = value2, ...
5
6 WHERE condition;