how to extract duplicates from two tables and put them in another

  • Thread starter Thread starter deedee
  • Start date Start date
D

deedee

Hi,

I have two tables (table 1 and table 2) with different fields except one
(emails). I would like to extract identical emails from table 1 and table 2
to another table 3 with fields from table 1 + table 2. Can I do that and how?
Thanks a lot
 
Hi,

I have two tables (table 1 and table 2) with different fields except one
(emails). I would like to extract identical emails from table 1 and table 2
to another table 3 with fields from table 1 + table 2. Can I do that and how?
Thanks a lot
Click to expand...

A query joining the two tables on the email field can do this:

SELECT [Table 1].<whatever>, [Table 2].<whatever>
FROM [Table 1] INNER JOIN [Table 2]
ON [Table 1]. = [Table 2].[email]
INTO newtablename
 
Back
Top