Set operations (SQL)
Appearance
UNION
Combines the results of two or more queries into a single result set consisting of all the rows belonging to all queries in the union.
©1988-2000 Microsoft Corporation. All Rights Reserved.
Also:
- Duplicates are removed.
- The two queries must have matching fields and data types inorder to join them.