Listing 10. Creating a View Table

CREATE VIEW ApptAndSalaryView<\n>
AS
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
;