>>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
>
>Your view of the rate table should be something like...
>
**************************************************************************************************************
THANK YOU FOR HELPING ME..JUST A FEW MORE QUESTIONS

WHAT IS Pv1-rate?
WHAT is m.code..?

my call log table name is view1 and the field i need is dialednr
the rate table's name is rates and the field that has the first 6 digits of the call named is code
now the part of the customer where i have stored the rate names to pull them down and asign the to my customer,,,table name rate_code and the field name is code

CREATE VIEW pv1_rate AS;
SELECT * ;
FROM rate ;
WHERE code = ?m.code

m.code = SUBS(callId,1,6)
USE pv1_rate

please help me i need it.......pleaseee..