Modify the Properties of a Join

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 Properties window, 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.

The properties of the join are modified.

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 Properties window, 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.

The properties of the join are modified.