Query Builder - Union tab

The Union tab shows the statements in your Union query and allows you to:

• Add / Delete statements from your query
• Change the Union operator
• Change the order of the statements in the list. This is useful for an advanced union query.
• Change the braketing of the statements. This is useful for an advanced union query.

Check Consistency

A Union query requires that the individual statements return the same number of columns, and that these columns have consistent data types.

AQT will check this and display the results in the bottom grid. This can be a great time saver if you are developing a query with a large number of statements.