34,838
社区成员




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