Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
For a list of all records from both tables, we can use a full join:
select first_name, last_name, order_date, order_amount
from customers c
full join orders o
on c.customer_id = o.customer_id
@agentzzk

This comment has been minimized.

Copy link

agentzzk commented Jul 21, 2016

"order_amount" should be "amount" as that is what the column name is set to in your example table.

This is error is present in other examples as well.

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.