Re: MYSQL reporting an error with subquery query

2007-01-29 Thread ViSolve DB Team
PROTECTED] To: mysql@lists.mysql.com 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

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` =

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 at