Isolates the common members of two or more result sets.
set1 «INTERSECT set2»
| 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. |
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.