split a row value according to a specific column

I have total value in table A and need to get row value in table B until reached value in table A. **Table A** ID|Available -|- 1|99 2|0 **Table B** ID|Rack|RequiredQty -|-|- 1|A|60 1|B|102 1|C|8 2|A|10 **Expected Results** ID|Rack|RequiredQty|FulfilledQty -|-|-|- 1|A|60|60 1|B|102|39 1|C|8|0 2|A|10|0