SELECT E.EmpNo, E.EmpName, P.PartName, P.Part1Name, P.Part3Name, D3.InfoName AS DutyName, D15.InfoName AS SexName
FROM dbo.HR_Employee AS E LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D2 ON E.EmployeeStationID = D2.AutoID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D1 ON E.DutyTypeID = D1.AutoID LEFT OUTER JOIN
dbo.V_PartSet AS P ON E.PartID = P.PartID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D ON D.AutoID = E.EmployeeTypeID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D3 ON D3.AutoID = E.DutyID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D10 ON D10.AutoID = E.NativeID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D11 ON D11.AutoID = E.NationID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D14 ON D14.AutoID = E.LeaveTypeID LEFT OUTER JOIN
dbo.V_HRDocumentSet AS D15 ON D15.AutoID = E.SexID
WHERE E.Incumbency = '1'
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。