Define the Join Type

8. What Do You See? There are three ways to define the Join properties: INNER, LEFT Outer and RIGHT Outer Join.

 

1. Inner join: Only include rows where the joined fields from both Tables are equal.

 

2. Left outer join: Include ALL records from 'tblReceipt' and only those records from 'tblMovieRented' where the joined fields are equal.

 

That means "Start with all of the ReceiptIDs in tblReceipt and look up the matching ReceiptIDs  in tblMovieRented."


3. Right outer join: Include ALL records from 'tblMovieRented' and only those records from '
tblReceipt' where the joined fields are equal.

 

That means "Start with the tblMovieRented and look up the ReceiptD that matches in tblReceipt."

 

We will explore this more when we work with the Action Queries, later. Keep Option 1. Click OK.

Relationship Tools ->Design->Tools->Edit Relationship

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Define Join Properties