MIS 370

Creating Outer Joins in MS Access

There are different types of joins. Most joins are Inner Joins – only the records that match from the two tables are shown. With an Outer Join, all records from one table are shown and any matching records from the other table are shown.

Creating an Outer Join may be done by editing the Join Properties between two tables. In the Query Design view, Right Click on the relationship line. In the pop-up menu, select [Join Properties]

In the Join Properties form, select the type of Join you want. There are three options

1: Inner Join

2: Left Outer Join (all from the left and any from the right)

3: Right Outer Join (all from the right and any from the left)

For db1-2, Tutorial 9, Step 10, it’s 2: -- a Left Outer Join.

Click [OK], and run the query.

Nulls

You will find all the values from the left table (Category) a few rows that have empty (Null) fields from the right table (Subcategory).