方法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
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
