About joins
A join defines how a query returns data from two information objects. The information objects may be based on different data sources. 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 Query Builder does not support right outer joins or full outer joins.

Additional Links:

Copyright Actuate Corporation 2012