A表:
B表:
查询A,B表都有的人,在A的所有信息
select * from A t where t.name in (select name from A minus select name from B)
select * from awhere 姓名 in (select 姓名 from A minus select 姓名 from B)