Distinct Union All

With Distinct Union All, Union All retrieves the distinct rows from the primary table and the secondary table.

For example, this table shows the records from the primary table that are used for the Distinct Union All output:

Employee Name	Employee ID	Employment Date
Jeffrey Jones	123	1/5/2009
Shalini Kumar	345	1/5/2009
Lupe Garcia	456	2/8/2009
Dominique Bisset	789	2/8/2009

This table shows the records from the secondary table that are used for the Distinct Union All output:

Employment Date	Employee Name
1/5/2009	Jeffrey Jones
3/7/2009	Sheila Watkins
9/23/2009	Dominique Bisset
9/23/2009	Tran Nguyen

This example shows the result set from the Distinct Union All joining of the two tables:

Employment Date
1/5/2009
2/8/2009
1/5/2009
9/23/2009
3/7/2009