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]
