I'm new here and I have a question. There is a query im running which fails to execute on our servers. We run MYSQL 5 locally, while our server runs 4.0.25. What puzzels me is why the code is not running. The code is as follows:
select DISTINCT id from  where =1 and NOT EXISTS (select  from  where =);
but the server tells us the following :
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS (select  from  where =) LIMIT
Can someone tell me whether mysql 4 supports NOT EXISTS? We even tried NOT IN, but no success...