Edit the Join Properties

There are three ways you can link tables. You can edit the Join Properties and select a join that includes:

1. All records that Match both tables.

2. All the records from the Left table.

3. All of the records from the right table.

 

Try it: Edit the Join Properties

Double click the line, or join, between tblMovieTitles and tblGenre. Now, change the Table Join to show all of the records from tblMovieTitles and only the records from tblGenre and tblRatings that match.

 

Why? This join lets you see all of the movies, even the titles that don't have a genre in your database.