-- 查询两字段值 select A.ITEM,B.ITEM from TABLE_A A LEFT JOIN TABLE_B B ON A.NAME=B.NAME -- WHERE B.ITEM IS NOT NULL ; --同步B表字段值到A表 UPDATE TABLE_A A SET A.ITEM =( select B.ITEM from TABLE_B B WHERE A.NAME=B.NAME ); --将A表中多个字段值映射到B表多个对应字段 UPDATE TABLE_A A SET (A.ITEM,A.ITEM_2) =( select B.ITEM,B.ITEM_2 from TABLE_B B WHERE A.NAME=B.NAME );