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;
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;
转载于:https://www.cnblogs.com/jm0213/archive/2011/09/15/2177789.html