Select Tables to Join

The first step to combining multiple tables is to list the tables you want. Click the Tables tab:

To	Do this
Add a table by its description	Click on the Visual Assist in the Table column. From the resulting form, type the table description in the Description field.
Add a table by its object name	Directly type in the table name in the Table column.

Note

As of JDE E1 Tools Release 9.1.5, you can join up to 15 tables in any type of join. Prior to that release, you could only join up to 3 tables if you use a one-to-many (OUTER) join. If you only use one-to-one (SIMPLE) joins, then you may only add up to 5 tables.

In JDE World and External Data, you join up to the maximum number of tables the database will allow.