按要求导出组织结构数据，SQL 查询语句

最新推荐文章于 2023-08-04 17:25:59 发布

杠杠峰

最新推荐文章于 2023-08-04 17:25:59 发布

阅读量1k

点赞数

文章标签： sql join

本文链接：https://blog.csdn.net/lmn13/article/details/7351375

版权

with jxs as (
-- 经销商
	select id as jxs_id -- 经销商
		, parent_id as jxs_parent_id -- 经销商上级
	from t_department
	where position_id = 5
)

,jl as (
-- 经理
	select jxs.*
		, t1.id as jl_id -- 经理
		, t1.parent_id as jl_parent_id -- 经理上级
	from jxs left join t_department t1 
		on jxs.jxs_parent_id = t1.id
) 
,bbz as (
-- 本部长
	select jl.*
		, t1.id as bbz_id -- 本部长
		, t1.parent_id as bbz_parent_id -- 本部长上级
	from jl left join t_department t1 
		on jl.jl_parent_id = t1.id
)
,ls as (
-- 理事
	select bbz.*
		, t1.id as ls_id -- 理事
		, t1.parent_id as ls_parent_id
	from bbz left join t_department t1
		on bbz.bbz_parent_id = t1.id
)
,fz as (
-- 副总
	select ls.*
		, t1.id as fz_id
	from ls left join t_department t1
		on ls.ls_parent_id = t1.id
	
)

select * from fz