Hi,
I was reading the manual and it said that the subselect is only available in 4.1 or using the 4.0.12 with the mysqld –new command line to start it. But it doesn’t working!! So I downloaded the 4.1 alpha version with the same problem. The error is: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near …. Any ideas? I need subselect working. Please help!!!