Outer Joins in Reports

Outer joins allow greater choice of data to include in a query. You can now specify the type of join you use to link files in a report.

To include this information: Create this type of join:

Only rows in which the values match in both files Inner join (default)

All the rows from the primary file and only matching rows from the secondary file Outer join

All the rows from the secondary file and only matching rows from the primary file Outer join