User`s guide

4 Using Database Explorer
4-22
Each row in the SQL Criteria panel has four columns to define your SQL query.
Column 1 Column 2 Column 3 Column 4
Column 1 defines
the SQL condition
type where the
supported values
are:
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• WHERE
• ORDER BY
• AND
• OR
Column 2
defines the
column names
for every table
that you select
in the Database
Browser pane.
Column 3 defines the
mathematical operator
for each row of SQL
statements where the
supported values are:
• =
• !=
• >
• <
• <=
• >=
• LIKE
• NOT LIKE
• IS
• IN
• NOT IN
• ASC
• DES
Depending on the
preceding condition of
the query statement,
Column 4 displays
column names for every
table that you select in
the Database Browser
pane.
Use multiple rows in the SQL Criteria panel to define multiple SQL query statements.
Query Rules Using the SQL Criteria Panel
The control options for the SQL Criteria panel depend on your selections in the
Database Browser pane. The SQL Criteria panel supports multiple rows for