I have a query that substracts two subqueries.My problem is that when the second query has no values, then
the results from the first query are also not shown. I have tried to place NZ in order to avoid that :
But nevertheless the results from the first query are not shown and obviously the NZ function is not used properly by me.
Can somebody help me ?
My entire query is the following :
SELECT InVa.grade, InVa.size, InVa.SumOfcartons AS [In], OutVa.SumOfcartons AS Out, NZ([InVa.SumOfcartons]-[OutVa.SumOfcartons]) AS stock, InVa.SumOfQuantity, OutVa.SumOfQuantity, NZ([InVa.SumOfQuantity]-[OutVa.SumOfQuantity]) AS items
FROM OutVa INNER JOIN InVa ON OutVa.grade = InVa.grade;