FULL OUTER JOIN

sql

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

Explanation

Useful for reconciliation reports and data comparison. Some databases require emulation instead of native support.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Join types at a glance

Return only rows that match on both sides.

Open In sheetsqlsame section

Keep all rows from the left table and match rows from the right when available.

Open In sheetsqlsame section

Keep all rows from the right table and match rows from the left when available.

Open In sheetsqlsame section

Produce the Cartesian product of two tables.

Open In sheetsqlsame section

Prefer primary keys and foreign keys over names or free-form text.

A `WHERE` clause can accidentally turn a left join into an inner join.