Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Relationships
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access training - Relationships
Resolved · Low Priority · Version Standard
Reply Wed 27 Jun 2007, 16:34Delegate Laura said...
For upcoming training course dates see: Pricing & availability
RE: Relationships
Hi Laura
An Inner join is a join that selects only those records from both database tables that have matching values.
Records with values in the joined field that do not appear in BOTH of the database tables will be excluded from the query.
An Outer join selects all of the records from ONE database table and ONLY those records in the second table that have matching values in the joined field.
Option 1 in the dialog box is the inner join (the default in Microsoft Access).
Options 2 and 3 represent outer joins.
Regards
Carlos
|