NOT IN

The NOT IN function tests whether the specified value is not found in one or more expressions.

NOT IN Syntax

Use the following syntax when incorporating the NOT IN function in queries:

NOT IN(test_value, expression1 [,...])

Where test_value is the value to test to see if it does not exist in any of the expressions that you specify.