es.id) AS employees_count
FROM
companies
LEFT JOIN locations ON (companies.id = locations.company_id)
LEFT JOIN employees ON (locations.id = employees .locations_id)
GROUP BY
companies.id
Thank you!
Nuno Mendes
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
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
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
