Removing duplicates

[John]

Hi

I have a contacts table with four fields Contact_ID, Company_ID, Forename
and Surname. As a result of recent data import, many companies have ended up
with duplicate contacts, so for instance Company_ID 109 will have multiple
contacts with the same forename and surname. What is the way to remove such
duplicates such that each company is left with only one contact of a
specific forename+surname set?

Thanks

Regards

 

[John W. Vinson]

Hi

I have a contacts table with four fields Contact_ID, Company_ID, Forename
and Surname. As a result of recent data import, many companies have ended up
with duplicate contacts, so for instance Company_ID 109 will have multiple
contacts with the same forename and surname. What is the way to remove such
duplicates such that each company is left with only one contact of a
specific forename+surname set?

Thanks

Regards

That's A Very Bad Idea.

Names are *not* unique! I know three gentlemen named Fred Brown, here in the
little town of Parma. What on Earth makes you think that there is one and only
one Fred Brown, or Robert Smith, or David Jones in your entire database?


John W. Vinson [MVP]

 

[John]

Its OK if they are within the same company i.e. with same company_id group.

Regards

 

[John W. Vinson]

Its OK if they are within the same company i.e. with same company_id group.

I once worked with Dr. Lawrence David Wise, Ph.D. and his colleague, Dr.
Lawrence David Wise, Ph.D.

Larry was tall, blond and affable. L. David was stocky, brunet and taciturn.

John W. Vinson [MVP]