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:

  1. Drag an Intersect operator from the Palette to the Design view.
  2. Connect two input relations to the Intersect Operator.
  3. Click the Intersect operator icon to examine the Details and Attributes sections.
  4. 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