Left Outer Join

Select e.last_name, e.department_id, d.department_name
From employees e LEFT OUTER JOIN departments d
On (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