actually i want to get stock balance each itemid wise as openingQty+purchases-issuedQty following is my query which is not give me sufficient and resulted query will show sum of each item three times whereas in the back end i have only one record.
SELECT dbo.IssuedDetail.ItemID, dbo.IssuedDetail.ItemName, dbo.IssuedDetail.Price, dbo.ItemsChartGo to the complete details ...