INTERSECT
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.