:
Fax to:
Subject: RE: Weeding out duplicates
07/10/2004 10:05
without the Internet and the amazing resource it makes everyone!
Regards,
Jonathan Duncan
Robert A. Rosenberg [EMAIL PROTECTED] 07/10 8:09 pm
At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
For the information of someone who may need it in the future
At 10:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
Lachlan,
I want to identify the entries in the table where the email addresses
are the same as another entry. Whatever else is in the record does not
matter to me.
However, a second requirement for the query
At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
For the information of someone who may need it in the future. I used
Jeffrey's idea for determining duplicates. Then I created a temporary
table, and used insert...select to put the id's of the duplicates
Lachlan,
I want to identify the entries in the table where the email addresses
are the same as another entry. Whatever else is in the record does not
matter to me.
However, a second requirement for the query is that it show me the last
duplicate instead of the first. This way I keep the first
For the information of someone who may need it in the future. I used
Jeffrey's idea for determining duplicates. Then I created a temporary
table, and used insert...select to put the id's of the duplicates in the
temporary table. Then it was a simple delete from table where
temp.id=table.id.
I am trying to get rid of duplicate user info entries in a database. I
am assuming that the email address is unique but other information, like
first name, last name, address, etc are not. The email field is not a
unique field in the database. I was trying something like the
following,
Jeffrey,
That actually does a good job, thank you. The reason I am doing this is
so that I can delete the duplicates. However, the query you gave me
shows me the first match of a duplicate. Is there a way to show the
last match of a duplicate instead? I am wanting to save the first
entries
Jonathan,
I'm not exactly sure what you want to do..
Do you want to identify the entries in the table where the email addresses
are the same as another entry but the name and address details differ...
or.. do you want to find entries where the name and address information is
the same but email