You are here: Re: My boss beats me « MsSQL Server « IT news, forums, messages
Re: My boss beats me

Posted by Robert Klemme on 10/02/15 11:48

NickName wrote:
> Hey Erland, haven't use the NG for a while hope you're doing well.
> I think his query looks like this,
>
> select t1.pkID, t2.pkID as pkID2
> from theTbl t1 INNER JOIN theTbl t2
> on t1.pkID = t2.pkID

Are you sure about the join on the same column? That would only join
every row with itself not very useful and certainly not helpful in
connecting records in a hierarchy.

Kind regards

robert

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация