Problem 9
What’s wrong with this query?
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;