MySQL 4.0.1 & MySQL 4.1.14

[mjlogan]

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]

[fenway]

Just for completeness, v4.0 doesn't support subqueries, but it can be re-written as a JOIN.