I'm trying to do the following SELECT statement:
SELECT * FROM matches WHERE question_id = ANY (SELECT server_id FROM questions WHERE results_id = 'MyID')
I've tried rephrasing it as:
SELECT * FROM matches WHERE question_id IN (SELECT server_id FROM questions WHERE questions.results_id = 'MyID')
And even:
SELECT * FROM matches WHERE question_id IN (SELECT q.server_id FROM questions as q WHERE q.results_id = 'MyID')
But no go--in all cases, I get an syntax error near the first parentheses.
Any suggestions? This is on MySQL 4.0.22-standard.
Thanks,
Adam Ernst
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
