Hi Guys,
I have two tables.
TABLE1
PRIORITY | CODE | QNTY |
1 | A | 10 |
1 | B | 22 |
2 | A | 5 |
2 | B | 20 |
2 | C | 10 |
TABLE 2
from above two tables I required below result.
PRIORITY | CODE | QNTY | AVL QNTY | |
1 | A | 10 | 25-10 =10 | (TOTAL AVL QUNTY IS 25) |
1 | B | 22 | 45-22=23 | (TOTAL AVL QUNTY IS 45) |
2 | A | 5 | 10-5 | (TOTAL AVL QUNTY IS 10, AS 10 ALREADY USED IN #1) |
2 | B | 20 | 23-20=3 | (TOTAL AVL QUNTY IS 22, AS 22 ALREADY USED IN #2) |
2 | C | 10 | 55-10 | (TOTAL AVL QUNTY IS 55) |
Please help..
Thanks
Sandeep