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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]