Skip to content

Instantly share code, notes, and snippets.

@dan81989

dan81989/right-join.sql

Created May 25, 2016 18:27
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/9d8858796184fdfc375b9d21fa3147f8 to your computer and use it in GitHub Desktop.
Save dan81989/9d8858796184fdfc375b9d21fa3147f8 to your computer and use it in GitHub Desktop.
Download ZIP
Right join is a mirror version of the left join and allows to get a list of all orders, appended with customer information, if such information is available:
Raw
right-join.sql
select first_name, last_name, order_date, order_amount
from customers c
right join orders o
on c.customer_id = o.customer_id
@sadhanamali
Copy link

can you explain where is
Order_date and order_amount in your table
07/21/1795 | $25.50
11/27/1787 | $14.40
please check in right join and respond

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment