-- 相同记录
INSERT M SELECT A.*
FROM A表 A
WHERE EXISTS(
SELECT * FROM B表
WHERE A.ID = ID
AND A.NAME = NAME)
-- 不相同记录
INSERT N
SELECT A.*
FROM A表 A
WHERE NOT EXISTS(
SELECT * FROM B表
WHERE A.ID = ID
AND A.NAME = NAME)
UNION ALL
SELECT A.*
FROM B表 A
WHERE NOT EXISTS(
SELECT * FROM A表
WHERE A.ID = ID
AND A.NAME = NAME)