ACCESS关联更新

写SQL SQLVER写习惯，ACCESS关联更新写了很久都写不对，还是GOOGLE了一下才搞出来，

备忘一下

 

UPDATE kssfxm AS A INNER JOIN KSBMB AS B ON A.KSID=B.KSID

SET A.KSBM = B.KSBM;