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
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