Concatenating Queries

Concatenate two queries having the same selected items.

The Query class methods for concatenating queries are:

Union(Query)
UnionAll(Query)
Except(Query)
Intersect(Query)

This example obtains the results from one query except for those results appearing in a second query:

Query query1 = new Query(); 
... ... //other code for query1

Query query2 = new Query();
... ... //other code for query 2

Query query3 = query1.Except(query2);
SMP101DB.ExecuteQuery(query3);