Hi
I am sorry for my earlier post of same heading, as this contains texts in machine language. I am posting my query again as below :
I have data across thousands of rows in Table 1 and want to match it with data in table 2 with some criteria.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
I want that if code & amount of table 2 (either amount as mentioned or amount + 50) matches with code & amount of Table 1, it should indicate in another column of table 2.
Please try to help me out.
Thank you.
I am sorry for my earlier post of same heading, as this contains texts in machine language. I am posting my query again as below :
I have data across thousands of rows in Table 1 and want to match it with data in table 2 with some criteria.
Table 1
CODE | AMOUNT |
70265 | 10,469 |
5844 | 997 |
5844 | 416 |
10080 | |
10080 | |
10080 | |
10600 | 3,132 |
11100 | |
11102 | 4,933 |
11102 | |
11102 | 808 |
11102 | 920 |
11249 | 24,817 |
11447 | |
73803 | 47407 |
11447 | |
11504 | |
11504 | |
11127 | 11,394 |
11510 | 1,536 |
11510 | 741 |
11510 | 3,199 |
11510 | 301 |
47180 | 149 |
11529 | 531 |
11529 | 441 |
11529 | 746 |
11529 | 723 |
11562 | 559 |
11562 | 815 |
11579 | |
72099 | 671 |
11579 | |
11627 | |
72861 | 7892 |
11651 | 2,812 |
<tbody>
</tbody>
Table 2
CODE | AMOUNT |
26351 | 257.00 |
70741 | 1,943.00 |
71218 | 1,018.00 |
46935 | 1,02,854.00 |
71406 | 7,867.00 |
26979 | 228.00 |
46318 | 4,438.00 |
47180 | 101.00 |
47180 | 131.00 |
47180 | 199.00 |
12285 | 424.00 |
39102 | 303.00 |
72099 | 671.00 |
72099 | 11,243.00 |
70531 | 40,352.00 |
26373 | 2,13,783.00 |
70244 | 16,889.00 |
42385 | 3,419.00 |
73803 | 47,457.00 |
72861 | 7,892.00 |
26655 | 834.00 |
<tbody>
</tbody>
I want that if code & amount of table 2 (either amount as mentioned or amount + 50) matches with code & amount of Table 1, it should indicate in another column of table 2.
Please try to help me out.
Thank you.