Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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:
select first_name, last_name, order_date, order_amount
from customers c
right join orders o
on c.customer_id = o.customer_id
@sadhanamali

This comment has been minimized.

Copy link

sadhanamali commented Jul 31, 2017

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
You can’t perform that action at this time.