查找丢失的数据

[qq_34477446]

我现在有表E和D，把D表中的数据导入到E表中，但中间缺失了几条数据，现在通过did这个字段怎么把缺失的数据从D表中找出来

[spiritofdragon]

select * from d where did not in (select did from e)

[唐诗三百首]

select a.* 
 from [D表] a
 left join [E表] b on a.did=b.did
 where b.did is null

[Ekun_sky]

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

[qq_34477446]

引用 1 楼 spiritofdragon 的回复:

select * from d where did not in (select did from e)

很有用