A query that combines corresponding fields from two or more tables or queries into one field. It's the equivalent of appending one table to another.
For example, a union query of the Customers table and the Suppliers table returns a result set that contains all the specified records from both the Customers table and the Suppliers table. The result set isn't updatable.