Access语句
update 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;
SQL Update实现使用一个表的数据更新另一张表
标签：
SQL Update实现使用一个表的数据更新另一张表
A SET A.mc = b.mc FROM A ,B WHERE A.bmbh = B.bmbh and A.xmbh = B.xmbh;