insert into A..table select t.* from B..table t where not exists(select 1 from A..table where 字段=t.字段)
假设a.table b.table 主键都为id INSERT INTO A SELECT * FROM B.TABLE WHERE B.TABLE.ID NOT IN ( SELECT B.ID FROM B.TABLE B INNER JOIN A.TABLE A ON A.COL1=B.COL1 AND A.COL2 = B.COL2.. )
select t.* from B..table t where not exists(select 1 from A..table where 字段=t.字段)
INSERT INTO A
SELECT * FROM B.TABLE WHERE B.TABLE.ID NOT IN
(
SELECT B.ID FROM B.TABLE B INNER JOIN A.TABLE A ON A.COL1=B.COL1 AND A.COL2 = B.COL2..
)