How to: Create UNION Queries
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.
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.
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see.
To create a Merged SELECT query
Open a query or create a new one.
In the SQL pane, type a valid UNION expression.
On the Query Designer menu, click Execute SQL to run the query.
Your UNION query is now formatted by Query Designer.