Second Fix, Problem 8
•Don’t null out recorded-by names just
because they were recorded by someone who is no longer an employee!
•This performs better!
•Are we
done?
SELECT C.Last_Name,
C.First_Name, CE.Event_Date, Ev.Name, EM.Last_Name, Em.First_Name
FROM Customers C, Customer_Events CE, Events
Ev, Persons Em
WHERE C.Customer_ID = :B1
AND C.Customer_ID =
CE.Customer_ID
AND CE.Event_ID =
Ev.Event_ID
AND CE.Recorded_By =
Em.Person_ID(+)
ORDER BY CE.Event_Date;