Key Fields
Primary Key uniquely identifies line to join
- May group several fields to get a unique key
- Social security number
- First and last name
“Foreign” key must appear in the other table
- But it need not be unique there
Join makes a new table
- Line specified by foreign key is tacked on