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"...
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-lReceived on Thu Mar 18 2010 - 09:43:06 CDT