34,588
社区成员
发帖
与我相关
我的任务
分享
select A.*
from table_A A
left join
(select DISTINCT AID from table_C where value='true' and BID=@ID) as B
on A.AID=B.AID
where isnull(B.AID,'')=''
select A.*
from table_A A
left join
(select DISTINCT AID from table_C where value='true') as B
on A.AID=B.AID
where isnull(B.AID,'')=''