IN Condition
The IN condition is satisfied when the expression to the left of the IN keyword is included in the list of values to the right of the keyword.
The following examples show the IN condition:
SELECT lname, fname, company FROM customer
WHERE state IN ('CA','WA', 'NJ');
SELECT * FROM cust_calls
WHERE user_id NOT IN (USER );
For more information, see the IN Subquery.