--b.typename是不是数字类型加一个rtrim
select a.*,
b.typename=case b.yc when 0 then rtrim(b.typename) else '隐藏' end
from A a left join B b on a.typeid=b.typeid
select a.*,
b.typename=case b.yc when 0 then rtrim(b.typename) else '隐藏' end
from A a left join B b on a.typeid=b.typeid
--b.typename应该是case when后列的别名,因此要将b.typename加单引号或改为你想要的列名
select a.*,'列名'=case b.yc when 0 then b.typename else '隐藏' end from A a left join B b on a.typeid=b.typeid
select a.*, typename=case b.yc when 0 then b.typename else '隐藏' end
from A a left join B b on a.typeid=b.typeid