Previous Topic

Next Topic

Book Contents

Book Index

Union Queries

The Query Builder has support for multiple Unioned statements.

An example of a Union query is:

Select * from SAMPLE.SALES_DETAILS_2015

union

Select * from SAMPLE.SALES_DETAILS_2016

union

Select * from SAMPLE.SALES_DETAILS_2017

union

Select * from SAMPLE.SALES_DETAILS_2018

This combines the results of multiple sets of data.

Creating a Union Query

Once you have built the first SQL statement in your query, you can add another statement with:

Building a Union query

Each Statement is Built Individually

With the Query Builder you build each statement individually:

Running the Query

When you Save the query, or copy it to the clipboard / SQL window, this will be the full query.

query_builder_union