Databases Reference
In-Depth Information
The
Simple
configuration allows us to set the commonly used conditions of
Field - Operator - Value
. For example, Field A = X will exclude all records from
the input table that have the value X in Field A. The operators available in this
wizard are shown in the screenshot below:
The
Advanced
option allows us to write the desired
Where Clause
by hand, whereas
the
Empty Template
will only add a
Where Clause
similar to the following:
Where (1 = 1)