I have two tables like this. Now I want to match the country,op_name and operator_code with the dialed number of table1. Each dialed number has a op_prefix on the beginning the the dialed number. but the op_prefixes are not same in length.
Here Olo and tirana have a four digit similar prefix. The result should output the best prefix matching.