Using the Union All Operator

See Also

The Union All operator combines elements from input relations, and captures one of every record in every relation and provides one of every record as output, including duplicates.

All input relations must have the same schema. Relations that are output from the Union All operator will have the same schema.

To create a Union All operator:

  1. Drag a Union All operator from the Palette to the Design view.
  2. Connect the input of the new Union All component to two or more operators that have Relation output.
  3. Double-click the Union All component. The property editor opens. Notice that the component has inherited the schema of its input relations.
  4. As needed, configure the following property: Name.
  5. (Optional) Click the Documentation tab and supply notes on this component.
  6. Click OK.
See Also
 
Using the Intersect Operator Property Editor
Using the Minus Operator Property Editor
Using the Union Operator Property Editor
 

Legal Notices