adding emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi, I have two tables in a mdb file both with fields called email. I want to
add up all the unique emails as one group. how do i do that? thanks for
your help.
 
paul69 said:
hi, I have two tables in a mdb file both with fields called email. I
want to add up all the unique emails as one group. how do i do that?
thanks for your help.
Click to expand...

SELECT EMail FROM Table1
UNION SELECT EMail FROM Table2

The union automatically eliminates duplicates.
 
Back
Top