Concatenating Queries

Concatenate two queries having the same selected items.

The SUPQuery class methods for concatenating queries are:

- (SUPCompositeQuery *)union:(SUPQuery *)otherQuery
- (SUPCompositeQuery *)unionAll:(SUPQuery *)otherQuery
- (SUPCompositeQuery *)except:(SUPQuery *)otherQuery
- (SUPCompositeQuery *)intersect:(SUPQuery *)otherQuery

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]