Iíve got table Employees (EmpNo, Ename, Mgr)
Where Mgr attribute is EmpNo of another Employee which means that if we have tuples
1 |John |2
2 |Mark| 7
Means that Mark is Johnís manager.
How can I obtain list of employees with ther managerís name as well as his number using only joins without any correlated(nested) subqueries?