Fixed Query 2, Alternative Fixes
SELECT O.Order_ID, O.Order_Date, C.Name, L.Quantity,
I.Name
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
ORDER BY O.Order_ID, L.Quantity, I.Name;
SELECT O.Order_ID, O.Order_Date, C.Name,
L.Quantity, I.Name
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 =
L.Shipping_Org_ID
AND C.Customer_ID =
O.Customer_ID
ORDER BY O.Order_ID, L.Quantity, I.Name;