SELECT employee.Id, employee.FullName, employee.ManagerId, manager.FullName as ManagerName FROM Employees employee JOIN Employees manager ON employee.ManagerId = manager.Id