Re: MYSQL reporting an error with subquery query

2007-01-29 Thread ViSolve DB Team
Hi, In your SQL statement you have used subquery. The subquery feature is introduced in MySQL version 4.1 and later. Thats why you are getting the Syntax error while running subquery in v4.0.24. Thanks, ViSolve DB Team - Original Message - From: "A Blossom of Paradise" <[EMAIL PROTE

Re: MYSQL reporting an error with subquery query

2007-01-22 Thread 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