You can use the actual item_ids however, 

Select * from items Where item_id IN (1, 2, 3, ..., n)


On 4 July 2013 23:16, Rui Vieira <ruidevieira@googlemail.com> wrote:
CQL does not support sub-queries.


On 4 July 2013 22:53, Tony Anecito <adanecito@yahoo.com> wrote:
Hi All,
 
I am using the DataStax driver and got prepared to work. When I tried to use the "IN" keyword with a SQL it did not work. According to DataStax IN should work.
 
So if I tried:
 
Select * from items Where item_id IN (Select item_id FROM users where user_id = ?)
 
 
Thanks for the feedback.
-Tony