cities.id
-Original Message-
From: Nuno Mendes [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 20, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: RE: Problem with sql sintax
I'm using 4.0.17. Isn't this SQL supported in this version?
Nuno Mendes
-Original Message-
Fro
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 su
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
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: ht
