Specifying a join

To define the joins for an information object, use the Joins page. For example, you can create the following SQL fragment:

FROM Customers INNER JOIN Orders ON (Customers.custID = Orders.custID)

About joins

A join specifies how to combine data from two maps or information objects. The maps or information objects do not have to be based on the same data source. A join consists of one or more conditions that must all be true. In the resulting SQL SELECT statement, join conditions are linked with AND.

A join can consist of multiple conditions in the following form:

columnA = columnB

A join can have only one condition that uses an operator other than equality (=) or an expression, for example:

columnA < columnB

Information Object Designer does not support right outer joins or full outer joins.

Copyright Actuate Corporation 2012