I have table with 5 or so fields and I am trying to eliminate records where there are duplicates based on the field UPIN. The whole record isn't duplicated but the UPIN value is. So the name,UPIN,credential would/could be duplicated but the zip,state, and specialty might be different. I need only unique (DISTINCT) records based on the UPIN field but I need the whole record.
Hope this isn't clear as mud.
Thanks,
Eric