On the design canvas, select the line that connects two query sources.
The window for the selected relationship family appears.
Select Join Properties.
The Join Properties window appears.
On the Join Propertieswindow, modify the join type to one of the following options, and then select Done:
Inner join, represented by the Only include rows that are linked through '<Relationship Family>' option.
Left outer join, represented by the Include ALL rows from '[<predecessor source>]' and only those rows from '[<successor source>]' where the joined fields are equal option.
Right outer join, represented by the Include ALL rows from '<Successor Family>' and only those rows from '<Predecessor Family>' that are linked through '<Relationship Family>' option.
On the design canvas, select the line that connects two query sources.
The Manual Join window appears.
Select Join Properties.
The Join Properties window appears.
On the Join Propertieswindow, you can modify the predecessor and successor fields, and then change the join type to one of the following options. Then, select Done:
Inner join, represented by the Only include rows where the joined fields from both tables are equal option.
Left outer join, represented by the Include ALL rows from '<Predecessor Family>' and only those rows from '<Successor Family>' where the joined fields are equal option.
Right outer join, represented by the Include ALL rows from '<Successor Family>' and only those rows from '<Predecessor Family>' where the joined fields are equal option.
