>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...
CREATE VIEW pv1_rate AS;
SELECT * ;
FROM rate ;
WHERE code = ?m.code
m.code = SUBS(callId,1,6)
USE pv1_rate
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown