FULL OUTER JOIN

A join returning matched rows plus unmatched rows from both sides.

What is FULL OUTER JOIN in a relational database?

FULL OUTER JOIN — A join returning matched rows plus unmatched rows from both sides.

SELECT customer.email, purchase_order.order_id
FROM customer
FULL OUTER JOIN purchase_order
    ON purchase_order.customer_id = customer.customer_id;

Level: Apprentice · More Database terms at this level

Updated