Working with Unions
You can work with union sub-queries by using the small panel in the top-right corner of the Query Building Area. Initially, there is only one union sub-query. It is labeled with the letter Q. To begin working with union sub-queries, right-click the Q and select New union sub-query.
When there are multiple union sub-queries, the available choices when you right-click the Q change.
With multiple unioin sub-queries, you can do the following:
Select Move Backward to move the sub-query (or bracket) to the top of the query (the topmost sub-query is the left one).
Select Move Forward to move the sub-query (or bracket) to the bottom of the query.
Select Remove to remove the sub-query.
Union Sub-query Bracket Operations
To enclose the sub-query in brackets, right-click the Q and select Enclose with brackets.
To remove the brackets from a sub-query, right click on the query bracket and select Remove brackets.
Union Operations
Right-click on the union () button between two queries to modify their union operand. The available union operands are:
Union
Union All
Except
Intersect