Problem 3
Consider a possible result:
2 lines, shipped to two addresses:
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;
ORDER_ID ORDER_DATE CUSTOMER QTY ITEM
-------- ---------- ---------- ---
----------------
38485
07-MAR-06 C. Millsap 1 SQL For Dummies
38485
07-MAR-06 C. Millsap 2 SQL For Dummies
What
if the second line had QTY=1 ?!?