Versions Compared

Old Version 2

changes.mady.by.user Rodrigo Rivero

Saved on

compared with

New Version Current

changes.mady.by.user user-eb51a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Alter the Join type options in such a way that you will see all Departments, whether they have matching Employee records or not.
Image Removed
Image Added

4.  Click the OK button.