How to show Record EmployeeName with respective Repoting ManagerName

Let us first create the same table for an employee.

One of the columns in the same table contains the ID of the manger, who is also an employee for the same company. Now all the employees and their managers are present in the same table.

Let us now connect the Employee table with itself with the help of INNER JOIN.

-- Inner Join--

SELECT e1.Employee EmployeeName, e2.Employee AS ManagerName FROM employee e1 INNER JOIN employee e2 ON e1.Manage_id = e2.ID -- Self Join -- SELECT A.Employee as EmployeeName , B.Employee as ManagerName From employee A , employee B WHERE A.Manage_id=B.ID Result Like That: