i want in sql one query

Question

Hi

        in two view i caluculate batch qty and one view issueqty when i select drug and from date two date i want to display the in between dates date batchqty,issueqty ,balanceqty  next row i sales some qty

 so balance today i enter 100 stock today issued 10 so balance 90 next day i sale one more 20 drugs prevoius balance batchqty 90  issue qty20 balance 70 lime that what problem is suppose i select tommarrow   enddate  batch qty today i enter so tomarrow batch qty comes zero so balance comes negitive what i want i want to check when i select form date and to date also need to check top 1  batch qtyis>0 that onw wards records need to display

any body can help for th