Hi, I have never written this kind of query, and I don’t have any idea where to begin. Some help would be appreciate.
What I have: I have a table with country name, country code, city code, and rate per minute, type (international or local).
I want to make a query which displays the total rate based on where they call and how many minute they used.
1)The problem with this is Some of the country code and city code are anywhere between 1-5 digits. Also, the phone numbers are 7-10 digits.
2) Some country code matches other country code first digit. example. Russia country code = 7, Australia= 715 (these are just examples)
3) Same thing with city codes. example: Russia country code = 7, cities codes in russia = 9, 906, 905, 912.
And I don’t want duplicate records.
I did made a query i will post it soon as I find it where I store it and edit this.
I have the same isssue…
When i test query, it gives only record when it matches countrycode and citycode.
say if i have missing citycode in my database, it will not return record base on countrycode.
If i have called to 91-265-123456 and 91-123456. and in my rate table i have
two record 91265 and 91.
but query gives result for 91265 only. so if i have missing or not matching citycode. it doesn’t work.
We havn’t figure it out, how to do query if we have missing citycode. If we get that query it will be easy to union two queries results.
As said we able to find records which has country code and citi code present.