UPDATE table1
SET field1=table2.field1,field2=table2.field2
FROM table2
WHERE table1.id=table2.id
UPDATE table1
SET field1=table2.field1,field2=table2.field2
FROM table2
WHERE table1.id=table2.id
转载于:https://www.cnblogs.com/xuweixia/p/10697651.html