The SQL Procedure

IN condition

Tests set membership.

Featured in: Joining Two Tables

sql-expression <NOT> IN (constant <,constant>...)

sql-expression <NOT> IN (query-expresssion)

constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals.
query-expression is described in query-expression .
sql-expression is described in sql-expression .

Details
An IN condition tests if the column value that is returned by the sql-expression on the left is a member of the set (of constants or values returned by the query-expression) on the right. If so, it selects rows based upon the column value. That is, the IN condition is true if the value of the left-hand operand is in the set of values that are defined by the right-hand operand.

Chapter Contents
Previous
Next
Top of Page