On Thursday 12 March 2009 19:28:19 Duffer Do wrote:
> I want to return the following:
> locations | number_visits
> Frankfurt | 6
> Manhattan | 3
> Talahassee | 0
>
> My query only returns:
> Frankfurt | 6
> Manhattan | 3
> My query:
> SELECT count(user_name) as number_visits, location_name from locations,
> user_tracker WHERE user_geometry && location_geometry
I think something like this:
SELECT count(user_name) as number_visits, location_name FROM locations LEFT
JOIN user_tracker ON (user_geometry && location_geometry)