How to: Create UNION Queries (Visual Database Tools)

The UNION keyword enables you to include the results of two SELECT statements in one resulting table. All rows returned from either SELECT statement are combined into the result of the UNION expression. For examples, see SELECT Examples (Transact-SQL) and Combining Results Sets with UNION

Note

The Diagram pane can only display one SELECT clause. Therefore, when you are working with a UNION query, Query Designer hides the Table Operations pane.

To create a Merged SELECT query

1. Open a query or create a new one.

2. In the SQL pane, type a valid UNION expression.

   The following example is a valid UNION expression.

   SELECT ProductModelID, Name
   FROM Production.ProductModel
   UNION
   SELECT ProductModelID, Name 
   FROM dbo.Gloves;
   

3. On the Query Designer menu, click Execute SQL to run the query.

   Your UNION query is now formatted by Query Designer.

See Also

Concepts

Supported Query Types (Visual Database Tools)
Combining Results Sets with UNION

Other Resources

Designing Queries and Views (Visual Database Tools)
Performing Basic Operations with Queries (Visual Database Tools)
UNION (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance