Summary

LCE231 - Join Query, including Unmatched Records

Important Observations

• Join Type Options allows you to specify the join type to be used between files joined in your query.
• Join Type Options is only available from the Query Window when you have more than one file open at the current level in your query.

The types of joins available are:

• All Records (Left Outer Join)

     Records from the primary file will be shown even if there are no matching records in the secondary joined file. For example, list customers with and customers without orders.

• Matched Records (Inner Join)

     Records from the primary file will only be shown if matching records in a secondary joined file are found. For example, list only customers with orders.

• Unmatched Records (Exception Join)

     Records from the primary file will only be listed if there are no matching records in the secondary joined file. For example, list only customers who have not placed any orders.