Concatenating Queries

Concatenate two queries having the same selected items.

The SUPQuery 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:

SUPQuery *query1 = [SUPQuery getInstance];
//other code for query1
    
SUPQuery *query2 = [SUPQuery getInstance];
//other code for query 2
    
SUPQuery *query3 = (SUPQuery*)[query1 except:query2];
[SUP101SUP101DB executeQuery:query3]