Specifying Join Conditions for Secondary Tables

When you work with secondary tables, you can specify join conditions by selecting parameters from controls in the Edit Table form. For more complex join conditions, you can specify the join conditions manually.

To specify join conditions by selecting parameters:

  1. In the IDO Tables form, click Add or Edit to add or edit a secondary table. The Edit Table or New Table form is displayed.
  2. In the first Join Conditions field, select the column in the current table being joined to.
  3. In the second Join Conditions field, select the table being joined.
  4. In the third Join Conditions field, select the column being joined.
  5. Click Add to display the conditions in the large edit box.
  6. Click OK.

To manually enter join conditions:

  1. In the IDO Tables form, click Add or Edit to add or edit a secondary table. The Edit Table or New Table form is displayed.
  2. Specify your join conditions as a SQL SELECT statement in the large edit box. If necessary, you can use the three Join Conditions fields to select columns and tables and insert them as parameters in your SQL statement. The parameters are inserted as AND statements.
  3. Click OK.