Link to home
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

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
create a query with a join on field [Email]
Avatar of Geekamo

ASKER

@ matthewspatrick,

Great, Thank you!

~ Geekamo