Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Review the Join Properties

In most queries, the joined fields are EQUAL. In this sample, the LEFT table is a small subset of the RIGHT. The LEFT table acts like a filter.

 

What happens when you include all records from tblMovieTItles and create a RIGHT join?

Query Tools -> Design
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries 

  4.2. Modify queries  4.2.3. Create joins: RIGHT (Join Properties dialog box: option 3)