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
Open a query or create a new one.
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;
On the Query Designer menu, click Execute SQL to run the query.
Your UNION query is now formatted by Query Designer.