This following steps describe how to apply the second filtered class SURNAME to the second column SURNAME of a data store CUSTOMER which has been included in a Method from the Work with Method window. The query is created with a UNION statement within the two filter criteria.
At the end of the Method confirmation phase, in order to apply the second class, copy the data store to a new step by clicking Copy Selected Step. To copy the data store:
To create a query with the INTERSECT statement, follow steps 1 through 4 above, and then: