The result will be a list of account numbers. My task is to count how many times a customer called within a month. The call table has the phone number that the customer called from. The customer table has the customer number, contact phone, home phone and work phone numbers. The customer may have called from different phone numbers associated with their account which is why I can't simply count the phone numbers in the call table. Once I have the list of account numbers then I will count those to get the number of times the customer called.
I could load the data multiple times and get the three phone numbers in the same field but that would triple my data. If I can create a field in the customer table that concatenates the phone numbers and then match any part of that concatenated field to the phone number in the call table, that will give me the account number without having to triple the data. I'm open to any suggestions on a better way to do this. Thanks.
