Union

All distinct rows selected by either query are retrieved. No duplicate rows are retrieved.

For example, suppose you have two teams:

Images shows an example of an Union query

To create a list of names on both teams without duplicating any names use the UNION operator in the following way:

Query 1: Queries names from Team A
UNION
Query 2: Queries names from Team B

The query returns:

Joe Conners
Raymond Shepherd
Lisa Grant
Tim Collins
Alison Standford
Elizabeth Davis
Lucy Brenner
Fred Lombart