方法1
select * from a where id + name not in (select id + name from b)
方法2
select a.* from a left join b on (a.id=b.id and a.name=b.name) where isnull(b.age)
SQL 两表关联 查询出A表中有但是B表中没有的数据 |字号 订阅方法1select * from a where id + name not in (select id + name from b)方法2select a.* from a left join b on (a.id=b.id and a.name=b.name) where i