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

• Next in forum: Re: sql query help
• Prev in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Thread view: Re: Please help quick statement check

[Reply to this message]