LJ Archive

Listing 9. Appointments and Salary Histories

SELECT P.name, A.appt_when, S.monthly_gross, S.as_of
  FROM People P, Appointments A, Salaries S
 WHERE P.person_id = A.person_id
   AND A.person_id = S.person_id
ORDER BY P.name, A.appt_when
;
LJ Archive