Jump to content


Photo

MySQL 4.0.1 & MySQL 4.1.14


  • This topic is locked This topic is locked
1 reply to this topic

#1 mjlogan

mjlogan
  • Members
  • PipPipPip
  • Advanced Member
  • 122 posts

Posted 03 October 2006 - 08:04 AM

SELECT * FROM table WHERE variableA=0 AND variableB=0 AND variableC NOT IN (SELECT variableC_REF FROM another_table)

That query works fine in v.4.1.14 but I cannot get it to work in 4.0.1, I have tried a few variations, but still the same errors.

Can anyone stop the obvious mistake?

Thanks
Mark

EDIT: NOT EXISTS does not work either.


[RESOLVED]

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 October 2006 - 02:44 PM

Just for completeness, v4.0 doesn't support subqueries, but it can be re-written as a JOIN.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users