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?
EDIT: NOT EXISTS does not work either.
MySQL 4.0.1 & MySQL 4.1.14
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users