Re: mysql query

[Felix Geerinckx]

on Wed, 10 Apr 2002 03:11:40 GMT, Andrey wrote:

> What is wrong with this query:
> 
> select  *  from MYTABLE where MYTABLE.entry NOT IN (select
> ANOTHERTABLE.entry from ANOTHERTABLE) 

Current stable versions (3.23.x) of MySQL do not support sub-selects.
See
        <http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html>

for a workaround.

-- 
felix