1、更新单列数据
update table1 A set (column1) =
(select column1 from table2 B where a.relColumn = b.relColumn )
2、更新多列数据
UPDATE TABLE a SET ( column01, colum02, column03 ) =
( SELECT b.column01, b.column02, b.column03 FROM table2 b
WHERE a.relColumn = b.relColumn)