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, loca
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 moveme
