Specifying a join
Information Object Query Builder supports adding a join condition to a query based on information objects. To add a join condition to an information object query, drag a column name from one IO and drop it in another IO.
For example, dragging the customerNumber column from the Customers IO and dropping it in the customerNumber column in the Orders IO causes the following SQL fragment to appear in a SQL query:
FROM Customers
INNER JOIN Orders ON (Customers.customerNumber = Orders.customerNumber)
The join condition specifies that the value of the customerNumber column in the Customers IO must match the value of the customerNumber column in the Orders IO. The query returns no rows for customer records having no matching order records.

Additional Links:

Copyright Actuate Corporation 2012