Skip to content

Instantly share code, notes, and snippets.

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

This comment has been minimized.

Copy link

@sadhanamali 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