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

[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

 

[John W. Vinson]

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

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