Access Query with Where Clause
Posted on 2013-05-24
I created the code below so when i am comparing these two tables, i retrieve only the results where the email address for a cell phone number is not the same. This would indicate the number has been reassigned to another user.
I thought i could just use a where clause indicating the email address in each table not being equal, but i keep receiving a popup to enter data.
What should my code look like to make this query function properly.
SELECT New_List.Email_Address, New_List.Cell_Number, Baseline.Cell_Number, Baseline.Email_Address
FROM Baseline RIGHT JOIN New_List ON Baseline.Cell_Number = New_List.Cell_Number