Question: What is Intersect?
What is Intersect?
The INTERSECT query allows you to return the results of two or more "select" queries. However, it only returns the rows selected by all queries. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results.
The syntax is as follows:
[SQL Statement 1] INTERSECT [SQL Statement 2]