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
Retrieve all of the records from two tables
Retrieve only the records that two tables don't have in common