Intersection

All distinct rows selected by both queries are retrieved.

For example, suppose you have two teams:

Image shows an example of an Intersection query

To create a query that finds the names common to both teams, use the INTERSECTION operator.

Query 1: Queries names from Team A
INTERSECTION
Query 2: Queries names from Team B

The query returns:

Lisa Grant
Raymond Shepherd