The NOT keyword may not be used in a column cell.

Message Text

The NOT keyword may not be used in a column cell.

Explanation

When entering a NOT EXIST subquery into the Column cell, enter just the EXIST clause. Then go to the Criteria cell and enter False for it.

See Also
Expressions Subquery Fundamentals
Filtering Rows with WHERE and HAVING Using the Select List
Query Fundamentals  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.