Jump to content

Archived

This topic is now archived and is closed to further replies.

JakeHarlan

NOT IT not working with subquery

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.