I have two tables: I want to compate emails in both tables based on last name.
I want to find everyone whose email is differnt from what we have on file to update it. the table we have on file is called [Data from pdf Latest] teh moste recent email is in the [WordCalendarDirectoryDump] table.
Here is my query , right now it appears to be ignoring the "not equal to" and returning eveything.
TIA
DougP
I want to find everyone whose email is differnt from what we have on file to update it. the table we have on file is called [Data from pdf Latest] teh moste recent email is in the [WordCalendarDirectoryDump] table.
Here is my query , right now it appears to be ignoring the "not equal to" and returning eveything.
Code:
SELECT [Data from pdf Latest].Lastname, WordCalendarDirectoryDump.Parents, [Data from pdf Latest].[EMail Address], WordCalendarDirectoryDump.email
FROM WordCalendarDirectoryDump INNER JOIN [Data from pdf Latest] ON WordCalendarDirectoryDump.Lastname = [Data from pdf Latest].Lastname
WHERE ((([Data from pdf Latest].[EMail Address])<>[WordCalendarDirectoryDump].[email]));
TIA
DougP