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