rptMovieRentedSQ:JOINS

As you added each Table to the Query, the Tables were JOINED by their Keys.

 

3. Try it: Review the JOINS

tblMovieRented.MovieID to

tblMovies.MovieID.

 

tblMovies.RentalPriceID to

tblRentalPrices.RentalPriceID.

 

Keep going...

Query Tools ->Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships