Join Options dialog

This dialog appears when you double-click the join button of a data source pre-join, a business cube join or a query join. It helps you to edit the conditions of the specified join. See the dialog.

The following are details about options in the dialog:

Join Mode

Displays the mode of the join.

Outer Join

Specifies to make the join an outer join.

Condition

Specifies the join conditions.

• Join Table
  Displays the tables on which the join is set up.
• Add Condition
  Adds a new condition line.
• Delete
  Deletes the selected condition line.
• Group
  Makes the selected conditions in one group. Conditions can also be added to an existing group by selecting the conditions and the group while holding the Ctrl button, and then clicking the Group button.
• Ungroup
  Makes the selected condition ungrouped.
• Up
  Moves the selected condition up to a higher level.
• Down
  Moves the selected condition or group down to a lower level.
• Logic
  Lists the logic operator.
  • And
    Logic operator And which is applied between this and the next line or between more than two lines of a group.
  • Or
    Logic operator Or which is applied to this and the next line.
  • And Not
    Logic operator And Not which is applied to this and the next line.
  • Or Not
    Logic operator Or Not which is applied to this and the next line.
• Column
  Specifies the column that will be used in the join condition.
• Operator
  Specifies the operator to compose the join condition.
  • =
    Displays values that are equal to each other.
  • >
    Displays values that are greater on the left side.
  • <
    Displays values that are greater on the right side.
  • >=
    Displays values that are greater than or equal to the left side.
  • <=
    Displays values that are greater than or equal to the right side.
  • <>
    Displays values that are not equal to each other.
• SQL Statement
  Displays the SQL statement of the join condition.

Delete Join

Deletes the join.

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays the help document about this feature.

Related topics:

• Defining the join relationships between tables
• Joining tables in a query
• Setting up and editing joins