Solved programming problem

Show the manger_name and his manager_name(manager of manager)

Source code

SELECT mng.FIRST_NAME,mng2.FIRST_NAME

FROM employees AS e

     JOIN

     employees AS mng

     ON e.MANAGER_ID = mng.EMPLOYEE_ID

 

    JOIN 

    employees as mng2 

    ON mng.MANAGER_ID = mng2.EMPLOYEE_ID;
Join the discussion

Add your comment