From: Scott Purcell [mailto:[EMAIL PROTECTED] > 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)
IN has been supported for a while, but subselects have not. SELECT * FROM table1 WHERE item_id IN (1, 2, 3, 4, 5) should work, but not a subselect. I'm not sure of subselect syntax, actually, or what (recent) version in which it was introduced. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]