select id,name,case when aaa=0 then aaa else aaa2 end 结果列 from (select id,name,aaa,(select name from 表 where 表.id=A.aaa) aaa2 from 表 A ) B
select* from (所在的表名);
