Problem with sql sintax

[Nuno Mendes]

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]