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