LCE231 - Join Query, include Unmatched 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


Before You Begin

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