I am having a hard time figuring this one out. Can anyone help?
I have two tables linked by primary/foreign key. Both tables have a very similar other field (email address). I need to run a query that will find all situations that the email address fields don't match.
Example)
Table 1: which has the foreign key field under "Siebel ID"
Table 2: which has the primary key field under "Opportunity ID"
Both tables have an email address field.
In table 1, I select a Siebel ID from the drop down linked to the Opportunity ID so the tables are related. Then I want to compare the email address fields in both tables and have the query show me all times that the two email address fields don't match.
I've tried the unmatched query in Access but not getting it to work. It only looks for nulls.
Can anyone help?