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
select no,bb+case tj when 0 then '等于' when 1 then '不等于' else '' end+dd from a,b,c where a.aa=c.zt and b.cc=c.jg
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 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
from a,b,c
where a.aa=c.zt and b.cc=c.jg
结论=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