Select e.last_name, e.department_id, d.department_nameFrom employees e LEFT OUTER JOIN departments dOn (e.department_id = d.department_id);
This syntax retrieves all rows in the EMPLOYEES table, which is the left table even if there is no match in the DEPARTMENTS table.
0 comments:
Post a Comment