34,590
社区成员
发帖
与我相关
我的任务
分享
select c.no,
结论=a.bb+case when tj = 0 then '等于' else '不等于' end + b.dd
from tablec c
left join tablea a on a.aa = c.zt
left join tableb b on b.cc = c.tj
select c.no,
(select a.bb from a where zt = a.aa),
case when tj = 0 then '等于' else '不等于' end,
(select b.dd from b where jg = b.cc)
from c