应该是这样吧。Select count(*) from A
inner join B
on A.a_id = B.a_id
inner join C
on C.a_id = B.a_id
where C.a = 1 and C.b = 2 and A.id not in (select distinct e_id from B)代码手写,可能有些许问题
inner join B
on A.a_id = B.a_id
inner join C
on C.a_id = B.a_id
where C.a = 1 and C.b = 2 and A.id not in (select distinct e_id from B)代码手写,可能有些许问题
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货