Creating Table Unions

Access the JD Edwards Business View Design form.

  1. From the Table/Column Selection, select either Union Mode or Union All Mode.

    The Union and Union All features are available only if all columns in one table also reside in the other table.

  2. Click Yes in the Business View Design Aid: Union/Union All Mode window.
  3. Select the tables for which you want to create a table union.
  4. If the business view contains multiple tables, the system automatically designates the first table that is added to the Selected Table pane as the primary table.

  5. The tables you select will appear in the Select Columns pane.
  6. Select the data items you want from the primary table. You can’t choose data items from the other tables. If you select Only Selected Columns, only the selected data items are displayed. You can use the Select All to select all the data items from the primary table.