access 关联表更新

UPDATE report1 AS A INNER JOIN MOF_List1 AS B ON A.ID=B.ID SET A.priority = B.priority;