...
In the Table Joins workspace you can create new relation.
To create a new table join:
- In the setup workspace, in the left navigation, click Table Joins.
You see the Table Joins workspace with the current list of table joins. - Click New Relation.
- From the Left Join Table drop-down list, select a table.
- From the Relation drop-down list, select an option
– =
– *= - From the Right Join Left Join Table drop-down list, select a table.
Click Save Relation.
You see the Confirmation dialog asking you to confirm your selection.All relations will be stored under one new relation ID and new join ID.
- Click Ok.
Create a New Join Column
In the Table Joins workspace you can create You can create a new join column in the Table Join workspace.
To create a new join column:
- In the table joins workspace, click create new join column.
You see the Join Column dialog box. - Select a Table Name from the drop-down list.
- Select a Column Name from the drop-down list.
- Click Save.
Edit a Table Join
You can You can edit a table join in the Table Join workspace.
- In the table join workspace, select the table join you want to edit by clicking on the corresponding check box.
- Click Edit.
- Update as needed and then click Save.
...