[SQLDownUnder] INNNER JOIN?

[William Luu]

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