Skip to content

Instantly share code, notes, and snippets.

@dan81989

dan81989/left-join-alt.sql

Created May 25, 2016 18:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dan81989/41de34784f09c5296df3765f981c805a to your computer and use it in GitHub Desktop.
Save dan81989/41de34784f09c5296df3765f981c805a to your computer and use it in GitHub Desktop.
Download ZIP
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:
Raw
left-join-alt.sql
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