Manager Table Name in SQL Server of Employee Master Data

[Former Member]

In Employee Master Data, there is a field for employee called manager. In SQL Server, that manager column is numeric (1,2,3 etc.) I want to know that what is the name of manager Table in SQL Server from where employee managers is coming??

[former_member212181]

Hi Saad Hamid,

That manager field is linked to employee master data (OHEM) again.

Please try below sample query.

SELECT T0.[empID],T0.LastName[Emp Last Name], T0.firstName[Emp First Name], T1.EmpID[manager ID],T1.LastName[Manager Last Name], T1.firstName[ManagerFirst Name]

FROM OHEM T0

Left Outer Join OHEM T1 on T0.Manager = T1.EmpID

Thanks

Unnikrishnan