To construct other types of joins, you must first understand how the information in one table is related to that in another.
The primary key for a table identifies each row in the table. Tables are related to each other using a foreign key.
This section shows how primary and foreign keys together let you construct queries from more than one table.
