FULL OUTER JOIN

FULL OUTER JOIN returns all rows when there is a match in either table.

SELECT customers.name, orders.id
FROM customers
FULL OUTER JOIN orders
ON customers.id = orders.customer_id;

• Unmatched rows will show NULL in the columns of the other table.