Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Why would such a left join be useful? Simply adding a “where order_date is NULL” line to our SQL query will return a list of all customers who have not placed an order:
select first_name, last_name, order_date, order_amount
from customers c
left join orders o
on c.customer_id = o.customer_id
where order_date is NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.