Defining a Join at the Column Level

To define which two Columns are joined, do the following:

1. Define the Table Descriptors in the Join; see Defining a Join at the Table Level.
2. In the Join properties screen, click Update. The system displays an Add Join Column button.
3. Click Add Join Column. The system displays a drop-down list under each Table Descriptor included in the Join.
4. For the Table Descriptor on the left, select the Column you want to define as part of the Column Join from the drop-down list.
5. For the Table Descriptor on the right, select the Column you want to define as part of the Column Join from the drop-down list.

   Note:

   The two Columns must have the same data type.

6. Click Apply. The system saves your work.

   Click Return to go back to the main Business Area screen.