查询员工及其上级sql

[适用版本]:8.2,8.5,8.5sp1

[解决方案]:

--查询所有员工的上级岗位及上级员工
select ADMINP.fdisplayname_l2 组织全名称,POSITION.Fname_l2 职位名称,POSITION.fnumber 职位编码,ADMINP.fnumber 组织编码,PERSON.fname_l2 员工姓名,PERSON.fnumber 员工编码, PPOSITION.Fname_l2 上级职位名称, PPOSITION.fnumber 上级职位编码 ,PPERSON.fname_l2 上级员工姓名,PPERSON.fnumber 上级员工编码,PPUSER.FIsDelete 上级用户状态,PPUSER.FForbidden 上级用户状态
FROM T_BD_PERSON PERSON
LEFT OUTER JOIN T_ORG_PositionMember PM ON PM.FPERSONID = PERSON.FID
LEFT OUTER JOIN T_ORG_Position POSITION ON POSITION.FID = PM.FPOSITIONID
LEFT OUTER JOIN T_ORG_ADMIN ADMINP ON ADMINP.FID = POSITION.FADMINORGUNITID
LEFT OUTER JOIN T_ORG_PositionHierarchy chierarchy on chierarchy.FChildID=POSITION.FID
LEFT OUTER JOIN T_ORG_