Except

All distinct rows selected by the first query, but not the second query, are retrieved.

For example, suppose you have two teams:

Image shows an example of an Except query

Use the Except operator to list only those members who are members of Team A and not both Team A and B.

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

The query returns:

Jim Conners
Tim Collins
Alison Standford