Jump to content

MySQL 4.0.1 & MySQL 4.1.14


mjlogan

Recommended Posts

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]
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.