You can create the following types of joins:

• Inner join — returns records where the values from both tables match.

  

• Left outer join — returns all records from the first table and any matching records from the second table.

  

• Right outer join — returns all records from the second table and any matching records from the first table.

  

1. On the Navigation bar, click Manage Manual Joins.
2. On the Manage Manual Joins tab, in the upper right corner, click Add a row.
3. In the From section, specify the following:
   • Connection Name — the connection that provides access to the table from which you want to create the first part of the join.
   • Table Name — the table from which you want to obtain the field.
   • Field Name — the field that you want to join with the other table.
4. In the To section, specify the following:
   • Connection Name — the connection that provides access to the table to which you want to create the first part of the join.
   • Table Name — the table to which you want to add the field.
   • Field Name — the field that you want to join with the other table.
5. Specify the type of join. For Join Type, choose one of the following:
   • Inner — returns records where the values from both tables match.
   • Left Outer — returns all records from the first table and any matching records from the second table.
   • Right Outer — returns all records from the second table and any matching records from the first table.
6. If you want to save your changes, click Save changes.
   • If you need to cancel your changes, click Discard changes .

1. On the Navigation bar, click Manage Manual Joins.
2. On the Manage Manual Joins grid, in the leftmost column, select the check boxes for two or more joins that you want to group.
   Each join that you want to group must have the same From and To table names.
3. In the upper right corner of the grid, click the group button.

   

4. In the Join Group Name dialog box, type a name for the group.
5. Click OK.

   The group is created.

1. On the Navigation bar, click Manage Manual Joins.
2. In the list, identify the join that you want to edit.
3. Click any of the fields and adjust the join definition as necessary.
4. Click Save changes.

1. On the Navigation bar, click Manage Manual Joins.
2. On the Manage Manual Joins page, select the join whose connections you want to view.

   The joins for that connection are displayed on the design surface.

1. On the Navigation bar, click Manage Manual Joins .
2. On the Manage Manual Joins page, double click in the Field Name column for the table you want to view.

   The table's fields are displayed.

Use this procedure for widgets, and for macros if joins have not been defined within the action. If you have created a join from within the action, see Access a visual join from the Statement Editor.

1. In the Statement Editor, click Add Statement.

   

   A blank statement ribbon is displayed.

   

2. Click , and specify the first table in the join.

   

3. Click , and specify the second table.

   

4. Click the next , and specify a field.

   

5. If necessary, add further statements to the query to include additional fields.

   

   Fields available for selection from a join are always from the second table specified in a statement. To include fields from both of the tables that make up a join, create additional statements.

1. On the Navigation bar, click Manage Manual Joins.
2. Do either of the following:
   Delete one or more joins

   • For each join that you want to delete, on the right side of the Manage Manual Joins grid, click Delete.
   Delete a group

   1. For each join that is part of the group, on the left side of the Manage Manual Joins grid, select the check box.
   2. In the upper right corner of the grid, click the ungroup button.

      

   3. In the Join Group Name dialog box, clear the group name from the field.
   4. Click OK.
3. In the upper right corner of the grid, click Save changes.