IN can contain a list of values or the result of a subquery and must match the data type of the field IN refers to.

where keyval IN (1,2,3,4,5)

OR

where keyval IN (select key from othertable where fkey IN (1,2,3,4,5))

OR

where myname IN ("eric", "erick", "erickc")

ETC...