Bad title. So I have two tables with phone number info and I'm trying to match them via a query. One table just has a phone number field [table1.phone] and the other table has a home [table2.homephone] & mobile phone number [table2.mobilephone] field. Basically I'm using the query to filter down to customers who are in both tables by matching the phone numbers.
Is there a way to match table 1's phone with either table 2 home or mobile. Just I dropped table 1 in the criteria for both, and basically it only matches instances where the same number is in both fields in table 2. Any ideas?