a,b 两表中不同的。。

[boytomato]

a 表如下

id name
001 dddd

b表如下
id bb cc
001 dd ddd
''



a 是用户表,b 是一张明细表。。。
想得到a 表中有,但b 表中没有的数据
也就是有个这个用户，但没有它的明细

[phantomMan]

select a.* from a left join b on a.id=b.id
where b.id is null

[liuchengit]

SELECT * FROM a WHERE a.id IS NOT IN (SELECT id FROM b)

[vivianfdlpw]

select * from a
where not exists(select 1 from b where id=a.id)

[ywqxtx]

学习

[QQMagicer]

select * from a
where a.id*=(select b.id from b group by b.id)
and a.id is null

[iwl]

select * from a
where id not in (select id from b )