List:General Discussion« Previous MessageNext Message »
From:Jay Pipes Date:September 25 2006 1:59pm
Subject:Re: Query missing rows in location of zip by distance
View as plain text  
On Mon, 2006-09-25 at 06:09 -0700, Steffan A. Cline wrote:
> Basically all 6 should come up in the big query because they are within the
> same zip and that any other locations within the same area. They all have
> the same latitude and longitude but only 1 shows up.

If they all have the same lat/long, then the distance from the centroid
of your supplied zip code will be the same for all 6.  Because you are
grouping on the distance, only 1 record will return.  Remove the GROUP
BY distance.

Cheers,

Jay

Thread
Query missing rows in location of zip by distanceSteffan A. Cline25 Sep
  • Re: Query missing rows in location of zip by distanceJay Pipes25 Sep
    • Re: Query missing rows in location of zip by distanceSteffan A. Cline25 Sep