NOT IT not working with subquery

[JakeHarlan]

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.

[gizmola]

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.