how to show all data in this querey

[grad2009]

hello guys,
i have a query that shows the balance of each item, here is the query

 
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,

[RuralGuy]

Use an OUTER or LEFT Join instead of an INNER Join.

[grad2009]

thanks alot RuralGuy
i did it and was ok
regards,

[RuralGuy]

Glad we could help.