INTERSECT

Isolates the common members of two or more result sets.

Syntax

set1 «INTERSECT set2»

Parameters

set1

A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure.

set2

A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure.

Comments

When used within a FIND command, the result set contains the members that are common to each of the specified result sets, with duplicates eliminated.

 

Related Topics