From: Dan Nelson
Date: January 23 2007 3:50am
Subject: Re: MYSQL reporting an error with subquery query
List-Archive: http://lists.mysql.com/mysql/204577
Message-Id: <20070123035041.GC4120@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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