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 using primary and foreign keys together lets you construct queries from more than one table.
