The information in this article applies to:
SYMPTOMSA SQL Select using the Not In clause with a subquery might incorrectly return no records. RESOLUTIONUse a user defined function in the subselect similar to the example below:
STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. MORE INFORMATIONIn the following cases, the main query could return an incorrect number of records:
-or-
The above queries return 0 records rather than all records in the table.
Steps to Reproduce Behavior
Additional query words: kbDSupport KBDSE kbVFp300bbug kbVFp500abug kbVFp600bug kbSQL
Keywords : |
Last Reviewed: December 10, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |