2,596
社区成员
发帖
与我相关
我的任务
分享
select distinct a
from BBB b
where not exists(select 1 from BBB where a=b.a and e not in (select e from CCC where d=1))
and not exists(select 1 from CCC where d=1 and e not in (select e from BBB where a=b.a))
select a.*
from aaa a, bbb b, ccc c
where a.b = 'm' and c.d = 11 and a.a = b.a and c.e = b.e
select a.*
from aaa a, bbb b, ccc c
where a.b = 'm' and c.d = 11 and a.a = b.a and c.e = b.e and a.a = 2