I'm a student and struggling with learning databases. Specifically the FULL OUTER JOIN query. I have items_ordered as my database and 2 tables that are Table 1: customers enter image description here Table 2: information enter image description here
I'm trying to get the following output.
CustomerID, LastName, Item, Quantity, and Price using FULL JOIN clause where Item or Quantity is null ORDER BY CustomerID.
Table 1 have CustomerID as primary key but Table 2 has Txn_no as its primary key. I tried this query.
SELECT customers.CustomerID, customers.Last_Name, information.Item, information.Quantity, information.Price FROM customers Full OUTER JOIN information ON information.CustomerID = customers.CustomerID
but an error pops out which is this enter image description here
However, I tried left join and it's working enter image description here
Can someone help me understand what I did wrong and why does my FULL OUTER JOIN query doesn't work?
