[Oracle] PL/SQL

SELECT d.department_id, d.department_name, e.last_name,  l.city
FROM departments d  left join employees e 
                                      on d.manager_id = e.employee_id
                                   left join locations l
                                      on d.location_id = l.location_id;

 

 

 

실행결과