Creating Table Joins

Access the JD Edwards Business View Design form.

1. If you are in Join Mode and select more than one table, the Table Joins pane and Column Joins pane appears.
2. Click the Add row button in the Table Joins pane, a table join is added.

3. Select a table from the Left Table drop-down menu and select a table from the Right Table drop-down menu. The Left Table drop/down and Right Table drop/down contains the list of tables selected from Selected Tables pane. You can add up to 15 tables for a table join.

   The selected data items for both the tables appear on the Left Table and Right Table tabs of the Column Joins form respectively.

   Note: If a join already exists for the two selected tables, the system shows an error.

4. Select an appropriate join type from the Join Type drop-down menu.

   Simple is the default join type.

5. To delete a table join, click Delete in the Table Joins pane.
6. Click Add in the Column Join form, a column join is added.

7. Select a column from the Left Table tab, the column is added as the Left Column of the join.

   Although the column names do not have to be the same, the attributes for Data Type and Decimals must be identical before you can create a table join between two columns.

8. Select a column from the Right Table tab, the column is added as the Right Column of the join.

   Select an appropriate operator from the Join Operator drop-down menu. Equal is the default join operator.

9. To delete a column join, click Delete in the Column Joins form. If you add more data items from the Selected Columns pane to the Left Table and Right Table tab, click Refresh to save the changes.
   Note: If you click Refresh, it will remove unsaved column joins.