Compare a table and a query to retrieve a NOT IN recordset.

F

FM

I am trying to retrieve qryDistroInA.Sku (query) that is not in PLocA.Sku
which in PLocA (table).

SELECT qryDistroInA.Sku, qryDistroInA.Suffix, qryDistroInA.ItemClass,
qryDistroInA.ItemSize, qryDistroInA.Units, qryDistroInA.Allocations,
qryDistroInA.[Units On Hand]
FROM qryDistroInA INNER JOIN PLocA ON qryDistroInA.Sku=PLocA.Sku
WHERE ((qryDistroInA.Sku) Not In (Select Sku from PLocA))
GROUP BY qryDistroInA.Sku, qryDistroInA.Suffix, qryDistroInA.ItemClass,
qryDistroInA.ItemSize, qryDistroInA.Units, qryDistroInA.Allocations,
qryDistroInA.[Units On Hand];

OR

SELECT qryDistroInA.*
FROM qryDistroInC INNER JOIN PLocA ON qryDistroInA.Sku= PLocA.Sku
WHERE ((qryDistroInC.Sku) Not In (Select Sku From PLocA));

From my data I know that there is one qryDistroInA.Sku that is not in PLocA.
But it keeps returning empty.
 
Top