Jump to content

Archived

This topic is now archived and is closed to further replies.

mjlogan

MySQL 4.0.1 & MySQL 4.1.14

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]

Share this post


Link to post
Share on other sites
Just for completeness, v4.0 doesn't support subqueries, but it can be re-written as a JOIN.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

×

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.