--在A表中查找
select * from A
where not exists
(select 1 from B where 编号=A.编号 and 姓名=A.姓名)
--在B表中查找
select * from B
where not exists
(select 1 from A where 编号=B.编号 and 姓名=B.姓名)
select * from A
where not exists
(select 1 from B where 编号=A.编号 and 姓名=A.姓名)
--在B表中查找
select * from B
where not exists
(select 1 from A where 编号=B.编号 and 姓名=B.姓名)
where not exists
(select 1 from A where 编号=b.编号 and 姓名=b.姓名)