How to define a join condition

1	In Information Object Query Builder, choose Query.

2	In Query, drag a column from an information object, and drop it in a column in another information object.

A join symbol like the one shown in Figure 2-5 appears between the join columns.

Figure 2-5

Examining a join in the graphical query editor

How to edit properties of a join condition

1	For a query that contains at least one join condition, select Joins.

2	In Joins, select the row that describes the join condition.

3	If necessary, select a different join condition operator from the drop-down list. By default, Information Object Query Builder uses the equality operator (=) to relate two columns.

4	To change a column name to an expression, select the column name, and type the expression. Alternatively, choose ellipsis to open the expression builder, as shown in Figure 2-6.

Figure 2-6

Defining a join condition

If the join has a condition that uses an operator other than = or an expression, the symbol shown in Figure 2-7 appears in Query.

Figure 2-7

A join that uses an expression or an operator other than equality

5	If the join consists of more than one condition, repeat this procedure for the other conditions.

6	Choose one of the following join types:

Inner join

Left outer join

7	Optimize the join.

Copyright Actuate Corporation 2012