Manage Table Joins

You can use the Table Joins workspace to add, edit and join database table columns.

Create a New Table Join

In the Table Joins workspace you can create new relation.

To create a new table join:

1. In the setup workspace, in the left navigation, click Table Joins.
   You see the Table Joins workspace with the current list of table joins.
2. Click New Relation.
3. From the Left Join Table drop-down list, select a table.
4. From the Relation drop-down list, select an option:
   –  =
   –  *=
5. From the Right Join Left Join Table drop-down list, select a table.

6. 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. 

7. Click Ok.

Create a New Join Column

You can create a new join column in the Table Join workspace.

To create a new join column:

1. In the table joins workspace, click create new join column.
   You see the Join Column dialog box.
2. Select a Table Name from the drop-down list.
3. Select a Column Name from the drop-down list.
4. Click Save.

Edit a Table Join

You can edit a table join in the Table Join workspace.

1. In the table join workspace, select the table join you want to edit by clicking on the corresponding check box.
2. Click Edit.
3. Update as needed and then click Save.

Delete a Table Join

You can delete a table join from the system.

To delete a table join:

1. In the table join workspace, select the table join you want to delete by clicking on the corresponding check box.
2. Click Delete.
   You see a confirmation box asking you to verify your selection.
3. Click Yes.
   The table join is deleted from the system.