Specifying join conditions for secondary tables

When you work with secondary tables, you must specify join conditions. You can accomplish this by selecting parameters from options in the IDO Table Wizard form, in the IDO Tables form, or in the Edit Table form. For more complex join conditions, you can specify the join conditions manually.

Specifying join conditions by selecting parameters

To specify join conditions by selecting parameters, use this procedure:

1. In the first Join Conditions field, select the column in the secondary table that is being used to join to the base table.
2. In the second field, select the primary or other base table being joined to.
3. In the third field, select the column in the base table being used for the join.
4. To add the join conditions statement in the Join Text edit field, click Add.
5. Optionally, to add other join conditions as needed, repeat the steps so far.
6. Click OK.

Specifying join conditions manually

You can specify join conditions manually, if you wish, in either the IDO Table Wizard form, the IDO Tables form, or the Edit Table form.

To do this, specify each join condition as a SQL SELECT statement in the Join Conditions edit field. You can specify multiple join conditions using AND statements.