Using UNION with Other Transact-SQL Statements

Follow these guidelines when using UNION with other Transact-SQL statements:

• The first query in the UNION statement can contain an INTO clause that creates a table to hold the final results set.

  The INTO clause can be used only in the first query; if it appears anywhere else, you get an error message. Also, remember that if the select into/bulkcopy option is not set, SELECT INTO can be used only to create temporary tables.

• ORDER BY and COMPUTE clauses to define the order of the final results or to compute summary values are allowed only at the end of the UNION statement. They cannot be used within the individual queries that make up the UNION statement.
• GROUP BY and HAVING clauses can be used within individual queries only; they cannot be used to affect the final results set.
• The UNION operator can also be used within an INSERT statement.
• The UNION operator cannot be used within a CREATE VIEW statement.
• The FOR BROWSE clause cannot be used in statements involving the UNION operator.