I have tableA that contains calling prefix and rates, ie
and tableB that contain phone number ie
I need to update tableB and set tableB.Rate = tableA.Rates. so basically depending on the prefix I have to set the rate on tableB.
So tableB should look like this:
How can I do this?