Suggest an editImprove this articleRefine the answer for “What does FULL OUTER JOIN do?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`FULL OUTER JOIN` combines the results of `LEFT JOIN` and `RIGHT JOIN` - it returns **all rows from both tables**, even when there's **no match** between them; wherever there's no match, the missing columns come back as `NULL`. **Key point:** the result has three groups of rows: customers with orders (merged), customers without orders (`NULL` on the `orders` side), and orders without customers (`NULL` on the `customers` side).Shown above the full answer for quick recall.Answer (EN)Image`FULL OUTER JOIN` combines the results of **LEFT JOIN** and **RIGHT JOIN** - it returns **all rows from both tables**, even when there's **no match** between them. Where there's a match, the rows are merged. Where there isn't, the missing columns come back as `NULL`. ### Example ```sql SELECT * FROM customers FULL OUTER JOIN orders ON customers.id = orders.customer_id; ``` Result: - customers with orders: merged; - customers without orders: `NULL` on the `orders` side; - orders without customers: `NULL` on the `customers` side.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.