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 an Intersect operator:
- Drag an Intersect operator from the Palette to the Design view.
- As needed, connect the input of the new Intersect component to two or more operators that have Relation output.
- Double-click the Intersect component. The property editor opens. Notice that the component has inherited the schema of its input relation(s).
- As needed, configure the following property: Name.
- (Optional) Click the Documentation tab and supply notes on this component.
- Click OK.
- See Also
-
- Using the Distinct Operator Property Editor
- Using the Minus Operator Property Editor
- Using the Union Operator Property Editor
- Using the Union All Operator Property Editor
Legal Notices