联表更新

mysql：

update A,B set A.c1= B.c1
where A.id = B.id

 

sqlserver:

update A SET A.c1=B.c1

from B 
WHERE A.id = B.id