gojets1721
Registered User.
- Local time
- Yesterday, 19:36
- Joined
- Jun 11, 2019
- Messages
- 429
So I've got two tables: Customers and Employees. For each group, there is a home phone and mobile phone listed. I've attached a very simple example DB
I'm trying to use a query to key in on matches in the phone numbers across the two tables. So if person 1's home phone in table1 matches a mobile in table2, boom that's a match. If person 2's mobile phone in table1 matches a home phone in table2, boom that's a match. And so on.
I thought it'd be fairly simple but its turned into quite a headache because it's four total fields and I'm unsure how to best design it. Any thoughts?
I'm trying to use a query to key in on matches in the phone numbers across the two tables. So if person 1's home phone in table1 matches a mobile in table2, boom that's a match. If person 2's mobile phone in table1 matches a home phone in table2, boom that's a match. And so on.
I thought it'd be fairly simple but its turned into quite a headache because it's four total fields and I'm unsure how to best design it. Any thoughts?