Re: MYSQL reporting an error with subquery query

2007-01-29 Thread ViSolve DB Team
t; <[EMAIL PROTECTED]> To: Sent: Tuesday, January 23, 2007 7:07 AM Subject: MYSQL reporting an error with subquery query Hello Fellow MySqueelers!, 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 sy

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

MYSQL reporting an error with subquery query

2007-01-22 Thread A Blossom of Paradise
Hello Fellow MySqueelers!, 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. query string is... SELECT RAND() AS `RAND`, `prod`.`id` FROM `prod` JOIN `pack` ON `prod`.`id` = `pack`.