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
按要求导出组织结构数据,SQL 查询语句
最新推荐文章于 2023-08-04 17:25:59 发布