Deviopath › PostgreSQL

Customers Who Never Ordered

Medium · Joins

A LEFT JOIN keeps every row of the left table. When there is no matching row on the right, the right columns are NULL. Checking for that NULL finds rows with no match.

Return the name and email of every customer who has never placed an order (of any status). Sort by name.

Next: Readable Order Lines