Hello all,
Can someone tell me How I can join a table (A) on a table (B) on a sorted column using a join condition so that only the first match is selected as the joined record?
For instance, I have:
Table A
Phone numbers
983357654
Table B
Prefixes
9833
983
98
9
I want to joib table A and B using the condition that the phone number is "LIKE" the prefix% . But I want only the first match , i.e. in this example 9833
Any ideas?