Translate

Tuesday, 2 December 2014

List all employee's names and their managers by manager name using an inner join

select distinct e.Ename as Employee, m.ManagerID as reports_to, m.Ename as Manager
from EMPLOYEES e
inner join Employees m on e.ManagerID = m.EmpID;

No comments:

Post a Comment