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.

query_builder_union1

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.

Advanced Query Tool

https://www.querytool.com