mjlogan Posted October 3, 2006 Share Posted October 3, 2006 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?ThanksMarkEDIT: NOT EXISTS does not work either.[RESOLVED] Link to comment https://forums.phpfreaks.com/topic/22836-mysql-401-mysql-4114/ Share on other sites More sharing options...
fenway Posted October 3, 2006 Share Posted October 3, 2006 Just for completeness, v4.0 doesn't support subqueries, but it can be re-written as a JOIN. Link to comment https://forums.phpfreaks.com/topic/22836-mysql-401-mysql-4114/#findComment-103084 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.