How to: Reference: |
Adding a UNION to a Data Flow lets you combine the results of two select statements into a single result set.
There are some restrictions on the select statements that can be used:
From the data flow workspace:
or
Right-click a SQL, JOIN or UNION object, select Add, then Union.
or
Drag the Union object from the Insert group of the Flow tab into the workspace.
The UNION object can be used to combine answer sets in different ways depending on the type selected in the Property page. The different UNION types are:
Object |
Function |
---|---|
|
Union Returns a result that contains all rows from both sets with duplicate rows removed. |
|
Union All Returns a result that contains all rows from both sets including duplicates. |
|
Except Returns a result set that contains all rows from the first set excluding common rows from the second set. |
|
Except All Returns a result set that contains all rows from the first set excluding common rows from the second set including duplicates. |
|
Intersect Returns a result set that contains the common rows from two result sets. |
|
Intersect All Returns a result set that contains the common rows from two result sets including duplicates. |
iWay Software |