MovieRentedSQ: JOINS
As you
added each Table to the Query, the Tables were JOINED by their Keys.
3.
Try it: Review the JOINS
tblMovieRented.CustomerID to
tblCustomers.CustomerID.
tblMovieRented.MovieID to
tblMovies.MovieID.
tblMovies.RentalPriceID to
tblRentalPrices.RentalPriceID.
Keep
going...