Using the Intersect Operator Property Editor
See Also
The Intersect operator enables definition of relation intersection. In effect, the operator behaves like the SQL INTERSECT command and acts as an AND operator (that is, values are selected only if they appear in all inputs provided to the operator).
All input schemas must be identical in format: column name and type must match for all attributes. You cannot select a subset of columns (attributes) from the input schemas, as you can when using the SQL INTERSECT command.
To create a Intersect operator:
- Drag an Intersect operator from the Palette to the Design view.
- Connect two input relations to the Intersect Operator.
- Click the Intersect operator icon to examine the Details and Attributes sections.
- Click Ok.
- See Also
-
-
- Using the Distinct Operator Property Editor
- Using the Tuple Based Window Operator Property Editor
-
- Using the Minus Operator Property Editor
- Using the Union Operator Property Editor
- Using the Union All Operator Property Editor
Legal Notices