subquery

[vncntj@hotmail.com]

SELECT venue_id FROM
(SELECT venue_id FROM nightave_dNight Ave.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

[Dikkie Dik]

Re: subquery

> SELECT venue_id FROM[color=blue]
> (SELECT venue_id FROM nightave_dNight Ave.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
>[/color]
MySQL did not support subqueries in that version.

[Kilo Bravo]

Re: subquery

Try using temporary tables instead of a subquery.

"Dikkie Dik" <nospam@nospam. org> wrote in message
news:d50a7$448b 04a7$57d40752$3 2427@news.versa tel.net...[color=blue][color=green]
>> SELECT venue_id FROM
>> (SELECT venue_id FROM nightave_dNight Ave.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
>>[/color]
> MySQL did not support subqueries in that version.[/color]