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]