Intersect

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 to the Intersect operator 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 with the SQL INTERSECT command.

To Create an Intersect Operator

1. Drag an Intersect operator from the Palette to the Design view.

2. Connect two input relations to the Intersect operator.

3. Double-click the Intersect operator.

   The property editor opens.

4. Examine the Details and Attributes sections.

5. (Optional) Click the Documentation tab and supply notes on this component.

6. Click OK.