Stock Qty shows as per Material Issue Slip [MIS]

Question

Hi I have two tables called Stock Table and MIS table. In stock tables fields are Stk_ItmNo Stk_Qty Stk_Location MIS tables columns are Mis_No Mis_Date Mis_ItmNo Mis_Qty What i'm looking for is suppose Stk_ItmNo Stk_Qty Stk_Location 111 4 A 222 6 B 333 8 A if Suppose 2-Dec-2016 is i made MIS for following items Mis_No Mis_Date Mis_ItmNo Mis_Qty MIS-0001 2-Dec-2016 111 2 MIS-0002 2-Dec-2016 222 1 then after issue MIS stock table will below Stk_ItmNo Stk_Qty Stk_Location 111 2 A 222 5 B 333 8 A what i want is when i'm checking stock report dated 1-dec-2016 then stock will be shown as below Stk_ItmNo Stk_Qty Stk_Location 111 4 A 222 6 B 333 8 A How to do this. Thanks Basit.

basit khan · Answer

What i tried is created a temporary table called Temp_Stock columns are temp_ItmNo temp_StockQty temp_Location then first enter whatever stock in stock table enter in Temp_Stock then check the MIS transaction and whatever select date after the MIS_Qty enter in Temp_Stock. How to do query in sql query Thanks Basit.

Mis_No	Mis_Date	Mis_ItmNo	Mis_Qty
MIS-0001	2-Dec-2016	111	2
MIS-0002	2-Dec-2016	222	1