HI All,
I need your assistance to write a script to get the match value between 2 tables
table 1
INvoice Amount
1234 500
Table2
INvoice amount
1234 25
1234 75
1234 100
1234 175
1234 180
1234 100
where in the above example i need to find the exact match for Table 1 by adding the table 2 values.(rows 1,3,4,6)
i need to perform all kind of combination search and find the rows whose sum will match the first table amount