查询员工及其上级sql

--查询所有员工的上级岗位及上级员工
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_Position PPOSITION ON PPOSITION.FID =