On Tue, Jun 16, 2009 at 1:59 PM, Carol
Cheung<cacheung@consumercontact.com> wrote:
> I would like to find the counts of complaints by region and I would like all
> regions to be displayed, regardless of whether or not complaints exist for
> that region. Is left outer join what I'm looking for?
SELECT R.region_name, Count(*) AS RegionComplaints FROM Region AS R
LEFT JOIN City AS Ci ON R.id = C.region_id
LEFT JOIN Complaint AS Cm ON Ci.id = Cm.city_idGROUP BY R.region_name;
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug