Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Build Queries Visually > Add Union Operators

Add Union Operators

A Union operator joins the results of rows from two or more SELECT statements. Any statement combined with a Union operator must have the same number of columns, and those columns must have the same data type and length. The following operators are available:

Union—Returns all rows found in any queried table, but removes any duplicate rows.
Union All—Returns all rows found in any queried table, including any duplicate rows.
Intersect—Returns only those rows that are in both queried tables that do not have duplicate rows.
Except—Returns all rows found in the first queried table that do not display in the second queried table.

Notes:

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To add a union operator

Select tables or views in the Query Builder and create a query.
Click the arrow beside the Union operator on the toolbar and select an operator: