Retrieve records from multiple tables

If your query contains more than one table, you can retrieve related records from multiple tables by using joins. A join is a link between two tables where a field in one table contains the same data as a field in another table.

What do you want to do?

Learn about retrieving records with inner and outer joins

Create an inner join

Create an outer join

Create a self join

Retrieve all of the records from two tables

Retrieve only the records that two tables don't have in common