graphic2
graphic1

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

Query Tools ->Design