Home
Corporate Marketer Guide
Corporate marketers develop templates for reusable campaign logic and lists of customer contacts.
About processes
Using queries to select data
When you configure a Select, Segment, or Extract process in a flowchart, you can use queries to identify contacts from your databases or flat files. There are several different query methods.
Guidelines for using raw SQL queries
Writing raw SQL is an advanced operation; users are responsible for correct syntax and query results.
To pass multiple commands in a raw SQL statement

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.

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.