In

The in predicate specifies a set of values to match in a where clause. The set can be specified with explicit values enclosed in parentheses or a select statement.

Syntax

 
    select * from ... 
    where val in (val1, .., valN)
     
    select * from ...
    where val in (select valX from ... where ...)
     

The first form of this expression is equivalent to:

 
    select * from ... 
    where val = val1 or val = val2 .. or val = valN
     

The not operator can be added to an expression using in:

 
    select * from ... 
    where val not in (val1, .., valN)
     

Examples

 
    create table names(s char(20));
    insert into names values(['Smith','Jones','Black','Clark','Adams']);
     
    select * from s where s in ('Jones','Smith');
    s
    ------------------------------------------------------------------------------
    Smith
    Jones
 
    Selected records: 2
     
    select * from names where s not in ('Jones','Smith');
    s
    ------------------------------------------------------------------------------
    Black
    Clark
    Adams
     
    Selected records: 3
     
    select * from s where s in (select s from names where s like 'A%');
    s
    ------------------------------------------------------------------------------
    Adams
     
    Selected records: 1
     

For more examples please see xSQL SDK sample in.