SQL Subquery

[ianicr]

I'm running mysql 4.0.16 on XP trying to do both or either of these queries from the mysql manual:
SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 IN (SELECT s1 FROM t2);
however I get a syntax error with the query in the brackets. Anyone know why?

 

[sleipnir214]

It would be because subqueries are not supported in MySQL prior to version 4.1.0.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[ianicr]

How stable is 4.1? I know its still in alpha but is it useable? Thanks

 

[sleipnir214]

It's alpha-revision software, so by definition it is not intended for a production environment.

However, you don't have to use subqueries to do what you want to do. Read:

http://www.mysql.com/doc/en/Rewriting_subqueries.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!