I have an excel sheet with two columns that have first and last names of clients in a database.
In the database there is a table named users with first / last / and email.
I basically want to get these first last names on the excel sheet, and find all matches in the database with their corresponding email address from the database and return the result.
What would be the best way of doing this? Here's a quick overview of what I said above:
excel sheet 2 columns
first | last
client database 3 columns in table users
first | last | email
sql query to run a find match on all names from excel sheet, then the database table named users, and return the matching email for each first / last name on the results.