Hi all,

I have tables of calling rates. I have 5 tables as follows:

_tblAccount - It's an account type such as pre paid or post paid
_tblEmployees
_tblProvider - list of all the providers. I have 7 so far.
_tblProviderRates - I have different rates from 7 different providers.
_tblReport - This is a detail table. I am importing EmployeeID,
ProviderID, ReportDate, CountryCode, and CallingSec in this table.

I want to include rates in this detail table from tblProviderRates.

For example, I have customers who have used 3 different providers with
3 different rates. I want to show them in my tblReport table.

Now, they supposed to match with calling codes as for example again;
provider A rates for CountryCode 1 is 0.009 and provider B rates for
CountryCode 1 is 0.010. I want to see these rates in my tblReport.
Once I have this I can do some artihmetic.

Thanks.