Problem 3
What’s wrong with this query?
SELECT DISTINCT O.Order_ID,
O.Order_Date, C.Name Customer, L.Quantity Qty, I.Name Item
FROM Orders O, Order_Lines L, Items I, Customers C
WHERE O.Customer_ID =
:B1
AND L.Order_ID =
O.Order_ID
AND
I.Item_ID = L.Item_ID
AND I.Org_ID =
:B2
AND
C.Customer_ID = O.Customer_ID;