Re: Only finding one record per ZIP code

You're exactly right, and that solved it! Thank you. On Nov 22, 2005, at 7:49 AM, [EMAIL PROTECTED] wrote: Brian Dunning <[EMAIL PROTECTED]> wrote on 11/22/2005 10:43:13 AM: > I'm using the following to find the nearest 10 records by proximity > to the ZIP code $zip. The problem is that

Re: Only finding one record per ZIP code

Brian Dunning <[EMAIL PROTECTED]> wrote on 11/22/2005 10:43:13 AM: > I'm using the following to find the nearest 10 records by proximity > to the ZIP code $zip. The problem is that it only returns one record > per ZIP code, even when there are multiple records with the same ZIP: > > (Note this

Only finding one record per ZIP code

I'm using the following to find the nearest 10 records by proximity to the ZIP code $zip. The problem is that it only returns one record per ZIP code, even when there are multiple records with the same ZIP: (Note this uses a temp table, but I already double-checked that all the desired reco