Using Advanced SQL Conditions in SBM Reports

SQL (Structured Query Language), is an ANSI-standard language for selecting records from a database.

A typical SQL selection statement looks something like this:

SELECT database_columns FROM database_table WHERE conditional_expression

Advanced SQL conditions provide you with two ways to implement or control your own SQL:

• Pass-through SQL – In some situations you can create a statement that includes a "where" clause. SBM pass-through SQL provides the flexibility to do this with the @ modifier.

  Note: Change History, Version Control Actions, and Multi-Table reports support the pass-through method "@" modifier only when you use an Advanced SQL condition. Privileges granted by your administrator determine whether you can create a report using Advanced SQL conditions.

• SBM–processed SQL – This automatically constructs most of the SQL statement behind the scenes. In most cases, you need to enter only the conditional_expression portion of the statement. You do not have to enter the WHERE keyword; SBM supplies this for you.

  Note: Privileges set by your administrator enable you to create Advanced SQL conditions and Advanced SQL conditions that use the pass-through method.