Step 6. Review the query options

LCE231 - Join Query, including Unmatched Records

1.  Investigate the results. Make sure the Department you recently inserted does not appear in your query since it does not have matching Employee records.

2.  Close the results window only. You should then be at the query window.

3.  From the toolbar select the Options menu and choose the Join Type Options command.

3.  Alter the Join type options in such a way that you will see all Departments, whether they have matching Employee records or not.

4.  Click the OK button.