如何通过员工表获取所属部门,经验贴
JacKie_Zhu
1人赞赏了该文章
1,474次浏览
编辑于2018年05月10日 08:33:07
select t1.fid ,t1.fnumber ,t2.fname ,t1.fstaffid ,t3.fdeptid ,t5.fname ,t3.FSTARTDATE
from
(
select fid ,fnumber ,FStaffId ,fpersonid
from T_HR_EMPINFO
where FDocumentStatus= 'C' and FForbidStatus = 'A' and FUseOrgId = '1'
) t1 ---员工基本信息表
left join T_HR_EMPINFO_L t2 on t1.fid =t2.fid ---员工名称信息比表
-- inner join t_BD_Person t3 ON (t1.fpersonid = t3.FPERSONID)
left join T_BD_STAFF t3 on t1.fpersonid = t3.fpersonid --员工任岗信息表通过主任职职员信息关联
left join t_Bd_Department t4 on t4.fdeptid =t3.fdeptid --部门
left join t_Bd_Department_l t5 on t4.fdeptid =t5.fdeptid --部门
where t2.fname = '马令'
from
(
select fid ,fnumber ,FStaffId ,fpersonid
from T_HR_EMPINFO
where FDocumentStatus= 'C' and FForbidStatus = 'A' and FUseOrgId = '1'
) t1 ---员工基本信息表
left join T_HR_EMPINFO_L t2 on t1.fid =t2.fid ---员工名称信息比表
-- inner join t_BD_Person t3 ON (t1.fpersonid = t3.FPERSONID)
left join T_BD_STAFF t3 on t1.fpersonid = t3.fpersonid --员工任岗信息表通过主任职职员信息关联
left join t_Bd_Department t4 on t4.fdeptid =t3.fdeptid --部门
left join t_Bd_Department_l t5 on t4.fdeptid =t5.fdeptid --部门
where t2.fname = '马令'
推荐阅读