Subquery problem

[protagonist]

Now this is odd. I'm running mysql Ver 12.22 Distrib 4.0.18, for apple-darwin6.8 (powerpc)
right?

And I can't get any subquery to work. I even tried
SELECT (SELECT 1);
and I still get
ERROR 1064: You have an error in your SQL syntax near 'SELECT 1)' at line 1

help?

 

[TonyGroves]

Sorry, sub-queries can't be used in MySQL until version 4.1 (currently alpha).

-----
ALTER world DROP injustice, ADD peace;

 

[protagonist]

Ah, that would explain it! thanks.