Intersection Operator

The Intersection operator produces a result set consisting of only those rows that are common to both of its inputs.

In computing the intersection, the operator compares all columns in each result set. The two input result sets must have identical schemas.

Related concepts
Input Source Element
Result Element
Aggregate Operator
Custom Operator
Generator Operator
Group By Operator
Iterator Operator
Join Operator
Multiplexer Operator
Order By Operator
Projection Operator
Select Operator
Splitter Operator
Union 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