The IN predicate can be used to compare a value with a set of values. If an IN predicate specifies a query expression, then the result table it returns can contain only a single column.
Syntax
This is the syntax for an IN predicate:
expression[ NOT ] IN
{ (query_expression) | (constant , constant[ , ...] ) }
