Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - 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 courses - Relationships
Resolved · Low Priority · Version Standard
Reply Tue 26 Jun 2007, 09:46Delegate Phil said...
Phil has attended:
Access Intermediate course
Relationships
What do the different join types between tables within a query mean?
For upcoming training course dates see: Pricing & availability
RE: Relationships
Hi Phil
Option 1 in the Joins dialog box is the inner join (the default in Microsoft Access).
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.
Options 2 and 3 represent outer joins.
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.
Regards
Carlos
|