Re: rewrite self joins using analytic functions

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Thu, 18 Mar 2010 22:43:06 +0800
Message-ID: <5e3048621003180743p5f9ab14ekd3fd5a99adb29397_at_mail.gmail.com>



> FROM
> tab1,tab2
>
>
>

Um....self join means table "X" joined to table "X"...

Your query doesn't have that....

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 18 2010 - 09:43:06 CDT

Original text of this message