hello guys,
i have a query that shows the balance of each item, here is the query
Code:
SELECT Items.itemNo, Items.itemName, Items.type, Items.unit, Sum(Transactions.qtyIn) AS totalProcurements , Sum(Transactions.qtyOut) AS totalSales,totalProcurements- totalSales AS balance
FROM Items INNER JOIN Transactions ON Items.itemNo=Transactions.ItemNo
GROUP BY Items.itemNo, Items.itemName, Items.type, Items.unit;
when i view data in this query it views only the items that have a value on the totalProcurements field, i want to view all the records even if the totalProcurements is zero.
i hope that you understand what i want
thanks with best regards,