User's Guide

Working with unions

Index  Previous  Next

You can work with union sub-queries using the small panel in the top-right corner of the Query Building Area. Initially there is only one union sub-query labeled with the "Q" letter. All required operations are performed by means of context drop-down menus.

• To add a new union sub-query, select the New Union SubQuery menu item.
  
• To enclose the sub-query in brackets, select the Enclose in Brackets menu item.
  
• To move the sub-query or bracket to the top of the query (the topmost sub-query is the left one), select the Move Backward menu item.
  
• To move the sub-query or bracket to the bottom of the query, select the Move Forward menu item.
  
• To remove the sub-query or bracket, select the Remove menu item.
  
• To change the uniting operator, select the necessary operator in the list of supported operators in the drop-down menu.
  

Union Sub-Query operations: Move Forward Move Backward New Union SubQuery Enclose In Brackets Remove
Operations with brackets: Move Forward Move Backward Remove Brackets
Select uniting operator

Index  Previous  Next