Link to home
Start Free TrialLog in
Avatar of Geekamo
GeekamoFlag for United States of America

asked on

Find Matching Email Addresses, Between Two Tables

Hello Experts!

I have two tables in my Database.

Tables - Blast1 & Blast2

Each table has two columns - ID & Email

I would like to run a query, that will display matching email addresses.

Example:

Blast1:

            ID                Email
             1                jamesdoe@doe.com
             2                jenny@lynn.com
             3                moth@draft.com

Blast2:

            ID                Email
             1                jamesdoe@doe.com
             2                sammy@beach.com
             3                bopp@math.com

Query - (should return only one record, based on the example tables above)

Only one email address in the example is present in both tables.

                                     Email
                            jamesdoe@doe.com


Thank you in advance for your help!

~ Geekamo
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
create a query with a join on field [Email]
Avatar of Geekamo

ASKER

@ matthewspatrick,

Great, Thank you!

~ Geekamo