When you specify a SQL SELECT statement for the top-level alias in the SQL tree, the SQL statement should include any WHERE statements or ORDER BY statements the SQL statement will use to issue the query. You will use the results of the top-level alias query as input parameters when you define the top-level's child aliases for the SQL tree.

Within the top-level alias's SQL statement you can define input variables that will be defined as service inputs when you configure a service using the transaction definition. To define a SQL statement's input as a variable, place the parameter between an ampersand (&) and an asterisk (*). You cannot define service input variables for non-top-level aliases.

When you specify a SQL statement for a child alias, define the SQL statement without defining the query's WHERE clause. You will define the input and join parameters for the child alias's SQL statement as the alias's relations. An alias's relations populate the child alias's input and join parameters using output values from alias's parent alias. You can also specify constant values as input parameters in a relation.

When you specify the query using a SQL SELECT statement, specify the alias's relations as name value pairs. Be sure to leave a space before and after the equals sign (=) in the name value pairs. For example:

The results of a child alias' SQL query statement will be stored as a child section of the results record. The resulting child record will be named the alias name. The output names in the child record will be based on the column names returned from the alias's SELECT statement.