Skip to content

Instantly share code, notes, and snippets.

@dan81989
Created May 25, 2016 18:30
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/e75f33b8c43765dd3194cea2f4cacdca to your computer and use it in GitHub Desktop.
Save dan81989/e75f33b8c43765dd3194cea2f4cacdca to your computer and use it in GitHub Desktop.
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
Copy link

"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