To add extra SQL statement

Many joins will have no further settings. However, if you wish to further customize your join by adding extra SQL statements in a join extension, do the following:

  1. Select a join.
  2. Click Add extension.
  3. Make the following settings:
    SQL for join extension

    Type your custom SQL code.

    Predefined variables

    Select a variable from one of the data source variables to be included in this SQL code (at the insertion point).

  4. Click OK.