Comparing Data From Excel To Dbase Field - TechRepublic
Question
August 5, 2014 at 02:03 PM
djpinson

Comparing Data From Excel To Dbase Field

by djpinson . Updated 11 years, 10 months ago

I have an excel spreadsheet that only has email addresses in a single columnar format on it (318 emails). I want to check and see if any of those emails are in the database. Is there a easier way than having to enter 300 “OR” statements? How do I do this?
SELECT “Name”.”FIRST_NAME”, “Name”.”LAST_NAME”, “Name”.”EMAIL”, “Name”.”ID”, “Name”.”MEMBER_TYPE”
FROM “APSCU_PROD”.”dbo”.”Name” “Name”
WHERE Name.EMAIL=’marie@bahoo.com’ OR Name.EMAIL=’markg@ts.com’ OR Name.EMAIL=’mare@t.edu’

Regards, DJ

This discussion is locked

All Comments