First Fix 7
SELECT O.Order_ID,
O.Order_Date, C.Name Customer, L.Type, L.Cost, L.Quantity Qty, I.Name Item, IT.Name Type
FROM Orders O, Order_Lines L, Items I, Customers C,
Item_Types IT
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
AND I.Item_Type_ID = IT.Item_Type_ID;
•The result is now consistent with the
original functionality, but is clearer to understand!