asked
Fuzzy Look Up or any other solution for partial match
Hi All, Please suggests me on the below scenario to find the solution. I have 2 Tables: Table 1: ![alt text][1] Table 2: ![alt text][2] I want to lookup (find the match) table 2 with table 1 and find the **Amount** based name and part number matches. Thanks, Kandan.M [1]: /storage/temp/3088-1.png [2]: /storage/temp/3089-2.png
You should be able to CROSS JOIN the two tables and in the WHERE part have table2.PartNumber like '%' + table1.PartNumber +'%' AND table1.Name = table2.Name I haven't tried this, but hopefully something like this will work: SELECT t1.Name,t1.PartNumber,SUM(AMOUNT)[SumAmount] FROM table1 t1 CROSS JOIN table2 t2 WHERE table2.PartNumber like '%' + table1.PartNumber +'%' AND table1.Name = table2.Name GROUP BY t1.Name,t1.PartNumber
18 People are following this question.
