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:

Notes: 

To add a union operator

  1. Select tables or views in the Query Builder and create a query.

  2. Click the arrow beside the Union operator on the toolbar and select an operator:


  

Related Topics

Build Queries Visually