User`s guide

Refine Results Using Query Criteria and Rules
4-23
specifying your query criteria. You can add more rows for these options in the SQL
Criteria panel by clicking +. You can remove a row by clicking -.
• If you select one table in the Database Browser pane, the available options for the
first query condition are WHERE and ORDER BY.
• If you select two tables in the Database Browser pane, the available options for the
first query condition are:
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• WHERE
• ORDER BY
• AND
• OR
• Press Enter or Tab to apply a condition for a row. The first (leftmost) column
contains query options that produce semantically correct SQL statements for each
subsequent condition that you add. For example, the leftmost column of an applied
condition contains an ORDER BY option. If you click + to add a query option in a new
row, the ORDER BY option can follow only another ORDER BY.
A Join option can follow only another JOIN or WHERE. A JOIN option cannot
follow a WHERE or ORDER BY option.
• When defining a query line for any conditions other than a JOIN, the line does not
take effect until you apply it. When you apply a condition, the software removes all
preceding and succeeding conditions that you did not apply from the SQL Criteria
panel. Similarly, if you click - to remove a query line, if you have applied that query
line, all succeeding conditions are removed. If you have not yet applied the query line,
the software removes only that line from the SQL Criteria panel.
• When using a WHERE SQL statement with a mathematical operator, to match a
string, include the string value in ' ' to apply the condition. If you use the LIKE or
NOT LIKE SQL operator to match a string, the software adds the ' ' to the string
value.