RE: [SQLDownUnder] INNNER JOIN?

[jmplun]

Maybe because the typo meant no results were returned in the exists
query, so all rows where returned from Items table?

Jarrad

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


Alright, I was looking through one of my stored procedures and see this
following query:

select ItemID from Items
where not exists
(select ItemID from Items INNNER JOIN Products 
ON Items.ItemID = Products.FK_ItemID)

I want to know why my typo (adding an extra 'N' in the INNER word),
actually yielded results, but when I corrected my typo, it didn't yield
any results at all.

I expect that it's probably something simple like using the wrong type
of join in the first place.

Cheers,

William


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