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.