根据参考表,update多个字段
update table1 t1
set (column1,column2)=
(select column1,column2 from table2 t2 where t1.colum3=t2.colum3);
根据参考表,update多个字段
update table1 t1
set (column1,column2)=
(select column1,column2 from table2 t2 where t1.colum3=t2.colum3);