Create Table Join Definitions
The Edit menu in the Reporter Join Query Editor lets you create, edit, or delete table join definitions.
To create a table join definition
1. Click a join icon in the Query Definition pane of the Query Editor.
The Reporter Join Query Editor appears—unless no joins are currently defined, in which case, OpenROAD automatically opens the Join Definition dialog.
2. Click Edit, Create in the Reporter Join Query Editor.
The Reporter Join Definition dialog appears.
To select columns for the table join definition
1. Click the folder icon to the right of the Column field associated with the Left Table.
The Select a Column dialog appears.
2. Select the name of the table in the Table Name list for which you want to specify a column.
3. Select the name of the desired column in the Column Name list.
4. Click Select (or press Enter) to add the selected column to the table join definition.
Repeat this procedure to add other columns to the table join definition.
In the Reporter Join Query Editor, the column selections are displayed under these headings: Left Table, Left Column, Right Table, and Right Column.
5. Click Close.
If all required joins between tables have not been defined, a confirmation pop-up dialog appears.
To edit joins
Click Edit, Edit Joins in the Query Editor.
You can modify the default joins, created when you added a table, to make them user-defined joins. User-defined joins are not recalculated automatically. Click Edit, Joins Research in the Query Editor to perform this operation. (The user-defined joins then become default joins.)