查询审批通过的离职单且已过离职日期,但是没有离职的员工

SELECT c.fname_l2,c.fnumber,a.FLEFTCOMPANYDATE ,d.fnumber FROM T_HR_RESIGNBIZBILLentry a

left join T_HR_EMPORGRELATION b on a.fid=b.FFlowInAffairID

left join T_B