In the last episode (Jan 23), A Blossom of Paradise said: > SELECT version() > > reveals... > > 4.0.24-nt-max-log > > I have looked at the following query a hundred times, and cannot find > how MYSQL can report a syntax error to me.
4.0 does not support subqueries. You will need to upgrade to at least 4.1, preferably 5.0. If you are stuck with 4.0, take a look at http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html for hints on rewriting the query using joins or temporary tables. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
