|
Posted by Kilo Bravo on 06/10/06 18:01
Try using temporary tables instead of a subquery.
"Dikkie Dik" <nospam@nospam.org> wrote in message
news:d50a7$448b04a7$57d40752$32427@news.versatel.net...
>> SELECT venue_id FROM
>> (SELECT venue_id FROM nightave_dNightAve.statistics
>> ) as tbl
>>
>>
>> I keep getting............
>>
>> You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT venue_id FROM statistics
>> ) as t
>>
>> I'm running MySQL Version 4.0.22
>>
> MySQL did not support subqueries in that version.
[Back to original message]
|