SQL Update：使用一个表的数据更新另一张表

表结构

功能

用表B的数据（mc列）更新表A的mc列

SQL Server

update A SET  =  FROM A ,B WHERE   =  and  = ;

Access

update A, B  set  =  where  =  and  = ;

或

update A INNER JOIN B ON  =  AND  =  SET  = ;