To pass multiple commands in a raw SQL statement
About this task
You can pass multiple commands in a raw SQL statement.
If your database allows multiple commands to be passed, you can enter as many valid SQL commands as you need, with the following rules:
- Commands are separated with the appropriate delimiter;
- The last command must be a select command;
- This select command must select all the relevant fields required in defining your audience level in the same order the audience level is defined;
- No other select statements are used.
Procedure
- Enable the Select records with option in the Source tab of the Select process.
- Click Advanced.
The Advanced Settings window appears.
- Click to enable Use Raw SQL.
This activates raw SQL, a feature that passes your exact query syntax to the database.
- Select the database to use and the desired audience level.
Click OK.
- Enter your SQL commands in the Select records with text box.
Click OK.