I need to make a query to compare a table containing a primary key and a list of e-mail adresses with a table containing a list of e-mail adresses and person numbers.
I then need to return these to the origianl list. I need a person number by each e-mail adress in the first table.
At the moment it keeps giving me the same blank 15 records.