UNION

The SQL UNION Operator combines two separate SQL macros.

select field1a, field2a, field3a

from table where . . .

UNION

select field1b, field2b, field3b

from table where . . .