Solved programming problem

Show the employee_id, his salary, his manager_id, his manager_name, his manager_salary

Source code

SELECT e.EMPLOYEE_ID,e.SALARY,e.MANAGER_ID,mng.FIRST_NAME,mng.SALARY

FROM employees AS e  

    JOIN

    employees AS mng 

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

Add your comment