To produce the same results as the INTERSECT operator,use the BETWEEN operator and a subquery.

Question

Quizplus · Accepted Answer

The BETWEEN operator and a subquery can be used to produce similar results as the INTERSECT operator, but they are not equivalent. The INTERSECT operator returns only the common rows between two queries, whereas the BETWEEN operator and subquery combination will return all rows from the first query that also exist in the subquery.

To Produce the Same Results as the INTERSECT Operator,use the BETWEEN