Introduction to Work with Method multiple filters

When more than one filter (single or combined) is added to the same data store, the sub-extraction query is created with UNION or INTERSECT SQL statements. This enables extraction of records that satisfy the filter criteria.

To better describe the two different situations, this guide divides the explanation in two different case:

For both cases, we used a DB2 table named CUSTOMER, with columns NAME and SURNAME and related class NAME and SURNAME.