Re: MYSQL reporting an error with subquery query

[Dan Nelson]

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
	dnelson@stripped