Maybe I'm misunderstanding that... I thought that was to return the top n% of the matches. I need it to return every client.

Thanks,

-Michelle

>Hi Michelle,
>
>I'd say you can use the Top clause that exists now in the Select SQL statement.
>
>Kind regards,
>
>Marc
>
>
>>I have a clients table and a locations table. Each client has and address that is in the locations table. I want to join the clients table to the locations table so I can replace the address in the clients table with the key to that address in the locations table.
>>
>>For the most part, there is only one of each address in the locations table. But because I'm working with bad data, there might be more than one.
>>
>>Is there a join that will take one and only one of each client and match it up to the first address in locations that it finds, and doesn't make a second entry of the same client for the second address in locations?
>>
>>Thanks,
>>
>>-Michelle