一个表的字段更新另一个表的字段

update table1 
set

field1 = table2.field1,
field2 = table2.field2
from table2
where table1.id = table2.id

 

转载于:https://www.cnblogs.com/appleat/p/9967836.html