The following statement generates a syntax error:
select questionKey from question where questionKey not in (select questionKey from userQuestionCount);
I ran the main query with values in place of the subquery and it runs correctly. I also successfully ran just the subquery...so the two querys are correct. When running them together I get a vague \"SQL syntax error...\" message.
Thanks in advance for your help.
NOT IT not working with subquery
1 reply to this topic
Posted 02 January 2004 - 09:41 AM
MySQL doesn\'t support subqueries, except perhaps in the most recently released (beta?) version(s). Check your version to determine the status... I don\'t keep abreast of what\'s going on with MySQL development status well enough to give you the specifics.
PHPFreaks is run by Volunteers like me. Want to say thanks? | Follow me on Twitter | My blog | Movie Review Site | Have you read the TOS?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users