34,590
社区成员
发帖
与我相关
我的任务
分享
select A.name_level1,B.name_level2,C.name_level3
from
(select id,parent_id,name as name_level1 from table where TYPE='省') as A
left join
(select id,parent_id,name as name_level2 from table where TYPE='市') as B ON A.id=B.parent_id
left join
(select id,parent_id,name as name_level3 from table where TYPE='县') as C ON B.id=C.parent_id
SELECT CASE WHEN 字段 = 1 THEN 字段 --不同条件
ELSE ''
END AS 列1 ,
CASE WHEN 字段 = 2 THEN 字段
ELSE ''
END AS 列2
FROM 表