Posted by Hugo Kornelis on 04/27/06 00:46

On 26 Apr 2006 07:50:47 -0700, David wrote:

>
>Hi,
>
>Is there a NOT operator in sql? I actually want NOT EXISTS as i believe
>these two statements would get a complete data set.

Hi David,

Yes. NOT EXISTS (subquery) is valid syntax.

--
Hugo Kornelis, SQL Server MVP

[Back to original message]