Query Issue

[kryten]

Hi everyone,

I have a query with the following SQL statement:

SELECT GoodsInQry.Code, GoodsInQry.Qty, Inventory2.SumofQty, [GoodsInQry].[Qty]-[Inventory2].[SumofQty] AS Onhand
FROM GoodsInQry INNER JOIN Inventory2 ON GoodsInQry.Code = Inventory2.Code;

Is it possible to show all records from GoodsInQry in the results even though some may have null values?

Any advice would be greatly appreciated.

 

[maxmangion]

use an Outer Join instead of Inner Join

 

[kryten]

Thanks! That worked.

 

[maxmangion]

You're welcome