Summary - FULL and CROSS JOIN

Write a missing supplier and customer report with FULL JOIN.

FULL OUTER JOIN keeps all rows from both tables; CROSS JOIN produces all pairs.

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

Summary full join.

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.

Exercise Summary - FULL and CROSS JOIN

Summary: FULL OUTER JOIN customers with orders.

Show example solution

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