Developer Tool Guide

Back Next

Right Outer Join Syntax

You can create a right outer join with a join override. The right outer join returns the same results as a left outer join if you reverse the order of the resources in the join syntax. Use only one right outer join in a join override. If you want to create more than one right outer join, try reversing the order of the source resources and changing the join types to left outer joins.

When you use a right outer join with other joins, enter the right outer join at the end of the join override.

To create a right outer join, use the following syntax:

{ source1RIGHT OUTER JOINsource2onjoin_condition }

The following table displays syntax for a right outer join in a join override:

Syntax	Description
source1	Source resource name. The Data Integration Service returns rows from this resource that match the join condition.
source2	Source resource name. With a right outer join, the Data Integration Service returns all rows in this resource.
join_condition	Condition for the join. Use syntax supported by the source database. You can combine multiple join conditions with the AND operator.

Rename Saved Search

Table of Contents

Developer Tool Guide

Developer Tool Guide

Right Outer Join Syntax

Right Outer Join Syntax