LCE231 - Join Query, include Unmatched Records

Objectives

• To list departments with and without matching employee records.

To achieve these objectives you will complete the following:

Step 1. Build a query over the Department file

Step 2. Run the query

Step 3. Add a new record to the Department file

Step 4. Build a query

Step 5. Run the query

Step 6. Review the query options

Step 7. Run the query again

Step 8. Save the retrieved data

Step 9. Save the query definition

Step 10. Change the Join Type

Summary

Before You Begin

You may wish to review the following topic in this guide:

• Join Type Options.