Combining two tables and separating duplicates

Hello,

I have two different mailing lists, one from company A and one from
company B. To prevent company A & B from sending duplicate
invitations, I would like to combine the two lists in Access using e-
mail addresses as a unique identifier. How do I query to find and
separate the duplicates into a separate table. The desired end result
would be one final mailing list (the duplicates identified and Company
A's mailing information kept) and one list with all the duplicate
contacts?

Thanks in advance!

.

Relevant Pages

  • Combining two tables and separating duplicates
    ... I have two different mailing lists, one from company A and one from ... mail addresses as a unique identifier. ... separate the duplicates into a separate table. ... A's mailing information kept) and one list with all the duplicate ...
    (microsoft.public.access.queries)
  • Re: Please disregard this message
    ... On Tue, 19 Apr 2005, Les Mikesell wrote: ... this issue is controversial on mailing lists so a lot of ... The following simple procmail rule will eleminate duplicate messages. ...
    (Fedora)
  • Re: current@ and freebsd-current@
    ... KMail parses the List-XXX headers that mailman sticks in messages to ... there is now way to turn this "feature" off ... mailing lists and have to duplicate it on N different machines. ...
    (freebsd-current)
  • Re: First general purpose unmoderated newsgroup for Debian
    ... >> Why fracture and duplicate the effort already taken care of by ... > Because we are fed up with people using pgp and gpg on emails to mailinglists. ... signed posts to Usenet than I see in mailing lists. ...
    (Debian-User)
  • Re: David Gerrold - War with the Cthorr
    ... If I lose one, I still have The Tempest, no matter which one I lose. ... They're separate instantiantiations of the same entity, but they ARE that entity, and neither one is lesser than the other. ... It's a physical impossibility, as that's the same group of atoms. ... cases you're dealing with an impossibly accurate duplicate. ...
    (rec.arts.sf.written)