Full Outer Join

Select e.last_name, e.department_id, d.department_name
From employees e FULL OUTER JOIN departments d
On (e.department_id = d.department_id);



This syntax retrieves all rows in the EMPLOYEES table, even if there is no match in the DEPARTMENTS table. It also retrieves all rows in the DEPARTMENTS table, even if there is no match in the EMPLOYEES table.