Union Operator

The Union operator produces a single result set that is the union of its two input result sets—a combination of everything in both inputs.

The two input result sets must have the same schema. Union provides the option of eliminating duplicate rows from the result set.

Related concepts
Input Source Element
Result Element
Aggregate Operator
Custom Operator
Generator Operator
Group By Operator
Intersection Operator
Iterator Operator
Join Operator
Multiplexer Operator
Order By Operator
Projection Operator
Select Operator
Splitter Operator
Update Operator

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com