职位已经无生效员工,但是禁用职位依旧提示有生效员工

执行此sql:

select relation.fpersonid from t_hr_emporgrelation relation inner join T_HR_EmpLaborRelationHis emplabor on emplabor.fhistoryrelateid = relation.FlaborRelationID and relation.Feffdt >= emplabor.feffdt and relation.feffdt < emplabor.fleffdt inner join t_hr_bdemployeetype emptype on emplabor.FLaborRelationStateID = emptype.fid where relation.FEFFD