union

Returns data for "set_expression1" and "set_expression2". The result retains duplicates only when the optional keyword "all" is supplied as the third argument.

Syntax

union ( set_expression1 , set_expression2 [ , all ] )

Example 1

union ( set ( [Camping Equipment] , [Golf Equipment] ) , set ( [Golf 
Equipment] , [Mountaineering Equipment] ) )

Result

Returns data for both sets as one new set, showing the Golf Equipment column only once.

Example 2

union ( set ( [Camping Equipment] , [Golf Equipment] ) , set ( [Golf 
Equipment] , [Mountaineering Equipment] ) , all )

Result

Returns data for both sets as one new set, showing the Golf Equipment column twice.