用户和员工所属部门关联SQL原创
2人赞赏了该文章
16次浏览
编辑于2024年09月30日 16:40:19
select E.FID, E_L.FNAME, P.FPERSONID, U.FUSERID, U.FNAME ,DPL.FDEPTID AS DEPTID from T_SEC_USER U inner join t_BD_Person P ON (u.FLINKOBJECT = P.FPERSONID) inner join T_HR_EmpInfo E ON (P.FPERSONID = E.FPERSONID) INNER JOIN T_BD_STAFF ST ON ST.FEMPINFOID = E.FID inner join T_BD_STAFFPOSTINFO as stInfo on st.FSTAFFID=stInfo.FSTAFFID and stInfo.FISFIRSTPOST =1 INNER JOIN T_BD_DEPARTMENT_L DPL ON DPL.FDEPTID = ST.FDEPTID left join T_HR_EmpInfo_L E_L ON (E.FID = E_L.FID AND E_L.FLOCALEID = 2052) where U.FUserId ={0}
推荐阅读