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;
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
No comments:
Post a Comment