What replaces IN?

[Scott Purcell]

I am trying to run the below query, and believe that the 'IN' is not supported in 
mysql. What is the 'IN' replacement? I tried exists and that doesn't work.

select * from table1
    where item_id IN (select item_id from table2)



Thanks,
Scott




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]