Jump to content


NOT IT not working with subquery

  • Please log in to reply
1 reply to this topic

#1 JakeHarlan

  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationFlorida

Posted 01 January 2004 - 04:16 PM

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.

#2 gizmola

  • Administrators
  • Advanced Member
  • 4,667 posts
  • LocationLos Angeles, CA USA

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.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users