Re: WHERE field IN (SELECT stmt) not working

[Michael Stassen]

It's not a bug.  MySQL 4.0.20 does not support subqueries.  You need 4.1 for 
that.  You can probably rewrite your query as a JOIN, however.  See the 
manual <http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html> for 
some suggestions.

Michael
Oliver Chua wrote:
Sorry if this has been posted as a bug.
I tried searching in the bug database but the word IN (which is the operative word here) 
is being ignored by the search engine...

I'm using mysql-4.0.20a-win.zip.
WHERE field IN (SELECT stmt) not working
but WHERE field IN ('literal1', 'literal2' ) is working
the former should be working as stated in the manual...
is it a bug and if it is, then what is the alternate solution?
thanks in advance.

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