Using the Union Operator
See Also
The Union operator combines elements from input relations. The Union operator captures one of every record in every relation and provides one of every record as output, with duplicates removed.
All input relations must have the same schema. Relations that are output from the Union operator will have the same schema.
To create a Union operator:
- Drag a Union operator from the Palette to the Design view.
- Connect the input of the new Union component to two or more operators that have Relation output.
- Double-click the Union component. The property editor opens. Notice that the component has inherited the schema of its input relations.
- As needed, configure the following property: Name.
- (Optional) Click the Documentation tab and supply notes on this component.
- Click OK.
- See Also
-
- Using the Intersect Operator Property Editor
- Using the Minus Operator Property Editor
- Using the Union All Operator Property Editor
-
Legal Notices