I'm using 4.0.17. Isn't this SQL supported in this version?

Nuno Mendes


-----Original Message-----
From: Colleen Dick 
Sent: Saturday, December 20, 2003 3:15 PM
To: Nuno Mendes
Cc: [EMAIL PROTECTED]
Subject: Re: Problem with sql sintax

What version you using?
Subselects are not supported in any except the latest

Nuno Mendes wrote:
> The sql bellow is giving a sql sintax error:
> 
> select
> cities.id,
> cities.name,
> (
>   select
>   count(*)
>   from images
>   where ( images.city_id = cities.id )
> ) as number_of_images
> from cities
> 
> Can you point me what am I doing wrong? Thank you!
> 
> Nuno



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to