can any body please help me
i have a record that has a customer id
i have a view in that record that does not have a customer id, but its assosiated with an inner joint

the clients page has a choice to choose the rate that belongs to hing to price all the calls accordingly

my rate table looks like this

code, country, rate 1, rate 2, rate 3, rate n
011575 Colombia .22 .23 .21 .28
011578 Peru .31 .36 .25 .27

now a customer in its view has a list of calls per say
0115758346254 duration 3 minutes
011853666666 duuration 4 minutes

i need to find out according to the firs six digits of the call made which country was it made to?
I need to find out at what rate are we billing him for..
Tip..the end user specifies in a field which rate this particular customer is using...Ex in thi case rate2