Creating and Using Stored Tables › Outlining an Application › Step 4: Establishing Join Columns

Step 4: Establishing Join Columns

What Join Columns Do

Since Fran plans to combine the JOB and APPLICANT tables to create the JOBS AND APPLICANTS view, she must establish a join column in each source table. A join column is a column in one table that is repeated in another table so that the two tables can be related.

Fran realizes that the TITLE column in the JOB table and the POSITION APPLIED FOR column in the APPLICANT table refer to the same piece of information. Since these columns will contain common values, they can serve as the join columns needed to create the JOBS AND APPLICANTS view.