Using Joins in Views

If you plan to use a join regularly, you can save it as a SQL script or you can create a view—a single virtual table—using the join as the logical representation of the data. After you create a view, the users never need to know that the data they are viewing is stored in multiple tables. To users, the relative complexity of your view is transparent. For example:

SELECT A.EMPLID,
       A.NAME,
       B.CONTACT_NAME,
       B.RELATIONSHIP
FROM   PS_PERSONAL_DATA A,
       PS_EMERGENCY_CNTCT B
WHERE  A.EMPLID = B.EMPLID;