摘要： 表结构功能用表B的数据（mc列）更新表A的mc列SQL Serverupdate A SET A.mc = b.mc FROM A ,B WHERE A.bmbh = B.bmbh and A.xmbh = B.xmbh;Accessupdate A, B set A.mc = B.mc where A.bmbh = B.bmbh and A.xmbh = B.xmbh;或update A INNER JOIN B ON A.bmbh = B.bmbh AND A.xmbh = B.xmbh SET A.mc = B.mc; 阅读全文