Problem 9
SELECT O.Order_ID, O.Due_Date,
E.First_Notification_Date, L.Item_ID
FROM Orders O, Order_Lines L, Order_Events E, Order_Line_Events
LE
WHERE O.Customer_ID = :B1
AND O.Order_ID =
L.Order_ID
AND O.Order_ID = E.Order_ID
AND E.Event_Type = 'LATE_SHIPMENT'
AND L.Line_ID = LE.Line_ID
ORDER BY O.Due_Date;
Order_Events and
Order_Line_Events both join to the same order, in any row this
query returns, but do they pertain to the same event?!?
This query implies significant built-in
assumptions: