Re: [SQL] select count of all overlapping geometries and return 0 if none.

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

[SQL] select count of all overlapping geometries and return 0 if none.

Hello all, I have 2 tables locations and user_tracker: locations has 2 columns location_name location_geometry user_tracker has 3 columns user_name user_geometry user_timestamp locations table is coordinates and names of areas of interest. user_tracker basically is an archive of a user's