Stock Qty shows as per Material Issue Slip [MIS]

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.