Third Fix, Problem 8
Now we are
done!
SELECT C.Last_Name,
C.First_Name,
CE.Event_Date, Ev.Name, EM.Last_Name, Em.First_Name
FROM Persons C, Customer_Events CE, Events Ev, Persons Em
WHERE C.Person_ID = :B1
AND C.Person_ID = CE.Customer_ID
AND CE.Event_ID =
Ev.Event_ID
AND CE.Recorded_By =
Em.Person_ID(+)
ORDER BY CE.Event_Date;