Counting rows when neither side fully matches

Question

Accepted Answer

FULL OUTER JOIN keeps all rows from both tables. Matched: Alice + Sales (1 row). Left-only: Bob (NULL dept_id, no match) - d.name is NULL. Right-only: Eng (no employee) - e.name is NULL. Total: 3 rows. FULL OUTER JOIN is the union of LEFT JOIN and RIGHT JOIN.