select outdt as date ,packsetid, shetkariid,
sum(inqty) as inqty,
sum(outqty) as outqty ,
sum(inqty - outqty) as Balance

will this balance be a running balance (i.e. yesterdays closing is todays opening)

rajesh