RE: [SQLDownUnder] INNNER JOIN?

[Wheat, Mitch]

Title: RE: [SQLDownUnder] INNNER JOIN?

The same applies to SQL Server. 'NOT EXISTS' is preferable to 'NOT IN' where applicable.

Regards,
Mitch

-----Original Message-----
From: Junying Xue [mailto:xuej@xxxxxxxxxxxxxx]
Sent: Wednesday, 9 March 2005 10:20 AM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [SQLDownUnder] INNNER JOIN?

I know for sure that there is a performance difference between "not in" and
"not exists" in Oracle.  How about in SQL Server?

-----Original Message-----
From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx
[mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of William Luu
Sent: Wednesday, 9 March 2005 11:25 AM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [SQLDownUnder] INNNER JOIN?

Thanks Aaron, that worked.

On Wed, 9 Mar 2005 11:16:06 +1100, Aaron Bull <aaron@xxxxxxxxxxxx> wrote:
<snip />
> select ItemID
> from Items
> where
> ItemID not in (select distinct FK_ItemID from Products)
>
> Cheers,
>
> Aaron
>

to unsubscribe to this list, please send a message back to the list with
'unsubscribe' as the subject. Powered by mailenable.com - List managed by
http://www.readify.net

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

EOM

---

EMAIL DISCLAIMER NOTICE

This message is the property of HATCH.  The information in this email is confidential and may be legally privileged. It is intended solely for the addressee.  Access to this email by anyone else is unauthorised.  If you are not the intended recipient, any disclosure, copying,distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

If you have received this message in error please notify HATCH immediately via e-mail to : mailadmin@xxxxxxxxxxxx

For more details about HATCH visit http://www.hatch.com.au

---