graphic2
graphic1

rptOverdueSQ: JOINS

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

 

2. Try it: Review the JOINS

tblMovieRented.MovieID to

tblMovies.MovieID.

 

tblMovies.RentalPriceID to

tblRentalPrices.RentalPriceID.

 

Keep going...

Query Tools ->Design