Solved programming problem

Show the employee_name and his country_name

Source code

SELECT e.FIRST_NAME,c.COUNTRY_NAME 

 FROM employees AS e

        JOIN 

        departments AS d

        ON e.DEPARTMENT_ID = d.DEPARTMENT_ID

 

        JOIN 

        locations AS l

        ON d.LOCATION_ID= l.LOCATION_ID

    

        JOIN

        countries AS c

        ON c.COUNTRY_ID = l.COUNTRY_ID;
Join the discussion

Add your comment