Re: [SQLDownUnder] INNNER JOIN?

[Damian Maclennan]

SQL Server has interperated INNNER as an alias for the Items table in
your subquery. Then it probably joined products to your original Items
table.

This probably gave some odd results before.



On Wed, 9 Mar 2005 11:05:21 +1100, William Luu <will.luu@xxxxxxxxx> wrote:
> 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