JakeHarlan Posted January 1, 2004 Share Posted January 1, 2004 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. Quote Link to comment https://forums.phpfreaks.com/topic/1590-not-it-not-working-with-subquery/ Share on other sites More sharing options...
gizmola Posted January 2, 2004 Share Posted January 2, 2004 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. Quote Link to comment https://forums.phpfreaks.com/topic/1590-not-it-not-working-with-subquery/#findComment-5217 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.