Quote:
i want to find the sum of ItemConsumptionEntry.nConsumeQty and ItemOutWordEntry.nOutQty
i want the difference between the total out qty and consume qty.
for that i am writing the query as below
SELECT dbo.ItemConsumptionEntry.nConsumeQty, dbo.ItemOutWordEntry.nOutQty, dbo.ItemConsumptionEntry.nItemOutWord
FROM dbo.ItemConsumptionEntry INNER JOIN
dbo.ItemOutWordEntry ON dbo.ItemConsumptionEntry.nItemOutWord = dbo.ItemOutWordEntry.nItemOutword
Try:
SELECT ICE.nItemOutWord, ICE.nConsumeQty + IWE.nOutQty AS SumOfSomething
FROM dbo.ItemConsumptionEntry AS ICE INNER JOIN dbo.ItemOutWordEntry AS IWE ON ICE.nItemOutWord = IWE.nItemOutword
I have no idea what you mean by
total qty...