FULL OUTER JOIN

Keep all rows from both tables.

FULL OUTER JOIN keeps every row from both tables. Unmatched rows come with NULL.

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

This query lists everyone, matched or not.

c.name, o.id is selected from customers c. orders o is joined on o.customer_id = c.id, keeping every row of both tables.

FULL OUTER JOIN — details

FULL OUTER JOIN combines LEFT and RIGHT JOIN. MySQL lacks it directly; you build it with UNION.

For example, a FULL OUTER JOIN of customers and orders includes both customers with no orders and orders with no customer.

Join customers with orders using FULL OUTER JOIN.

Show example solution

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

Add FULL OUTER JOIN

SELECT c.name, o.id
FROM customers c
____ orders o ON o.customer_id = c.id;

Show answer

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

Next lesson: CROSS JOIN