mysql关联更新记录

MYSQL

update a,b set col=0 where a.id=b.id

SQLServer

update table set col=val from table, table1 where table.id=table1.id;