select E2.Name,E1.Name from Employee E1 JOIN Employee E2 on E1.EmpId=E2.ManagerId

Select Employee name, Manager name from Employee

Is this a question?