Enter Database Query

Use the SQL query tab of the Enter Database Query dialog to specify criteria that Vector AM can use to select the data for this view, then select the Preview tab to check the results of the query.

To specify the selection query:

1    Type a SELECT statement that identifies the Clients you want to include in the group.

2    When you have specified all the selection conditions for the group, select the Preview tab to list the Clients that will be returned by your query.

3    Click Finish to close the Wizard and create the view.

Related topics

Combining Data from Multiple Tables

Example Filter Expressions

Logical and Compound Operators

Using Client Properties in Filter Expressions

Using Dates in Filter Expressions