Open topic with navigation

> The structure of a report / Join tables / Join properties

Join properties

Getting to these setting

Choose Report > Joins. The Join Editor appears. Click the join between the tables you want to work with, and view the Properties pane to the right of the Join Editor.

Setting	Description
Conditional Join Type	Conditional joins are used when the report's Include Records with No Transactions property is set to True. See Include records without transactions. You can use different join types to include/exclude records. Inner: Returns all rows from multiple tables where the join condition is met. Outer: Returns all rows from one table and only those rows from a secondary table where the joined files are equal.
From Field	Displays the variable used in the parent table.
Join Type	Inner: When a match is found in both tables the information is returned to the report. ParentOuter: Returns all information from the parent table and any matching information from the child table, including blanks. ChildOuter: Returns all information from the child table and any matching information from the parent table, including blanks. FullOuter: Returns all information from both the parent and child tables.
To Field	Displays the variable used in the child table.