1、首先查询A表中有,但是B表中没有的数据
SELECT a.* FROM bank_sxf a WHERE a.branch_union_code not IN (SELECT b.branch_union_code FROM bank b)
2、将查询到的数据插入B表
insert into bank (SELECT a.* FROM bank_sxf a WHERE a.branch_union_code not IN (SELECT b.branch_union_code FROM bank b))