Add an inclusion test (IN) predicate to an SQL statement

The IN predicate compares a value or values with a collection of values.

These steps are part of the larger task of adding search conditions to an SQL statement (WHERE or HAVING clause). When you complete the steps for adding a simple comparison predicate to an SQL statement, return to Add search conditions to an SQL statement (WHERE or HAVING clause).

To add an inclusion test (IN) predicate to an SQL statement:

  1. In the Operator list, specify the type of test to perform:
  2. In the Value table, specify values for comparison. You can:
  3. Optional: Click to open a window where you can create an expression.
  4. Optional: Click to open a window where you can select from a list of unique value for this column in the current database.

Return to Add search conditions to an SQL statement (WHERE or HAVING clause)