Specifying a Join Rule

To select data from more than one table, construct a join rule that specifies how the database relates the rows in one table to the rows in another table. If you do not construct a join rule, the database relates EVERY row in one table to EVERY row in the other table, which produces an extremely large quantity of output and causes performance problems for other users.

To specify a join rule, use the Restrictions tab.

The number of join rules you specify should be one less than the number of tables from which you select data. Some join rules may include more than one segment.