FULL OUTER JOIN: Returns all rows from both tables, with matching rows where?

available. If there’s no match, NULL is returned for the missing side.

• Use case: When you want all records from both tables.