table 1
APP_ID
1
3
table 2
APP_ID Profile_NUM
1 001AAA
2 001AAA
3 001AAA
1 000A223
2 000A223
1 01A345
2 01A345
1 0909
3 0909
5 BASS1
6 BASS1
7 BASS1
I would Like to perform the following:
. read table 1
. match table 1 against table 2, using App_ID column, and return
the following Profile_Num from table 2:
. 0909 - exact match
. 001AAA - close matches
. 000A223 - close match
. 01A345 - close match
THANKS!