Geekamo
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
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.
jamesdoe@doe.com
Thank you in advance for your help!
~ Geekamo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
create a query with a join on field [Email]
ASKER
@ matthewspatrick,
Great, Thank you!
~ Geekamo
Great, Thank you!
~ Geekamo