How to search a table based on a seperate list of names.
Posted on 2011-03-21
I need to search a Microsoft SQL 2000 database table called Candidates for email addresses for a seperate list of names I was given.
My list has columns for First Name, Last Name, Title, Company, Address, City, State, Zip, etc. The Candidate table has most of these fields and many others. I believe the Company and Address information is actually in a Companies table, linked to the Candidates table.
So my first question is how do I search the table based on information from my list?
Then, I get really confused thinking of how to make sure I'm pulling the correct information. All I need is the email address for each name on my list. But the database is huge, so how do I make sure I have the correct person? I can't be sure the company name or address information will be spelled or written exactly in the database table as it is in my list.
Any help with even part of this would be greatly appreciated. If it makes it easier or better for anyone, I can breake the question into multiple questions.