Fixed Query 6
SELECT O.Order_ID,
O.Order_Date, C.Name Customer, L.Type, L.Cost, 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;
•Now, the outer join is clean: order
lines are never discarded, and performance is better!