select * from a where not exists(select 1 from b where email=a. email) and not exists(select 1 from c where email=a. email)

------解决方案--------------------
1.select * from a where email not in (select email from b) and email not in(elect email from c)
lz这样不好使么。

------解决方案--------------------
select * from a  
where not exists(select 1 from b where a.email=b.email)
and not exists(select 1 from c where a.email=c.email)


------解决方案--------------------
SQL code
select * from a  
where not exists(select 1 from b where a.email=b.email)
and not exists(select 1 from c where a.email=c.email)

select a.* from a  
join b
on a.email=b.email
join c
on a.email=c.email
where b.email is null and c.email is null