34,594
社区成员
发帖
与我相关
我的任务
分享
select A.*,B.* from aa A left join bb B on A.ID=B.ID WHERE A.Type =1
UNION ALL
select A.*,B.* from aa A left join CC B on A.ID=B.ID WHERE A.Type <>1
select A.*,B.* from aa A left join bb B on A.ID=B.ID WHERE A.Type =1
UNION ALL
select A.*,B.* from aa A left join bb B on A.ID=B.ID WHERE A.Type <>1
select
A.*,B.*
from
aa A
left join (select case A.Type when 1 then bb else cc end from b ) B on A.ID=B.ID