In this version of the expression editor, you can specify
an expression in a WHERE expression, a HAVING expression, or a join
condition. The expression editor windows are numbered to show how
deeply they are nested.
Calculation predicate
When you use the Calculation predicate, you specify the
left value, right value, and calculation operator in the expression
editor.
Functions predicate
When you use the functions predicate, you can specify the
function, description, and function parameters in the expression editor.
Case predicate
When you use the case predicate, you can include case statements
in the SQL that you build in the expression editor.