Solved programming problem

Show the department_name and the manager_name of this department

Source code

SELECT d.DEPARTMENT_NAME,e.FIRST_NAME

FROM departments AS d  

    JOIN

    employees AS e  

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

Add your comment