microsoft access courses - 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