• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

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
0
Geekamo
Asked:
Geekamo
1 Solution
 
Patrick MatthewsCommented:
SELECT b1.Email
FROM Blast1 b1 INNER JOIN Blast2 b2 ON b1.Email = b2.Email
0
 
Rey Obrero (Capricorn1)Commented:
create a query with a join on field [Email]
0
 
GeekamoAuthor Commented:
@ matthewspatrick,

Great, Thank you!

~ Geekamo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now