Alternate to "Not In"

[pat15]

That is too slow.

any alternate ways?

 

[pat15]

For those who will search the forum for an answer
<Before>
SELECT tblProduct.Id
FROM tblProduct
WHERE (((tblProduct.Id) Not In (SELECT Id FROM qryProductOut)));

<After>
SELECT tblProductDetail.ProductId
FROM tblProductDetail LEFT JOIN qryStockOut ON tblProductDetail.StockId = qryStockOut.Id
WHERE qryStockOut.Id IS NULL


Extreme performance boost.

 

[Pat Hartman]

Subselects are not properly optimized by Jet. Joins are always faster.