I have a table that has names and address and an address number. There are multiple address numbers but the names may be different. I only need one record for each address number and it doesn't matter which name i pulls. How can I accomplish this.
Thanks,