How to get balance quantity ??

[Anonymous]

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

CODE	TOTAL QNTY
A	25
B	45
C	55

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