two table's two columns value deduction using SqlServer DataReader & Command Object

See more:

C#

Windows

SQL-Server

application

Hello Friends

i need your helps in my project that is IMS(Inventory Management System) there is two table 1st is stock Entry in it there is material name, materialQuantity,MaterialUnitCost and Material Total Cost value columns
2nd table that is ProductMaterialEntry table have same columns along with product Name.and it is describing that one product using 4 material(that is 4 row value like M1,M2,M3,M4....with quantity for this product unitcost and total cost.)

i have to do deduction between two tables columns on productRelease button click event...

for example : stock table have name of material and his quantity in stock that is multiply by UnitCost and its giving total cost for this material in Stock.now there is 4 row material like a material M1 have 10 quantity in stock M2 have 15 m3 have 20...so on


and another table maked a product that using quantity 5 of M1 ,10 of M2, 15 of M3......now i have to deduct all 4 rows quantity columns with where clause .....but there is multiple row simultaneously that need to deduction....

i am close with ma work on it the only issue with me that how to deduct multiple rows with two different tables.....

need your help genius