Re: rewrite self joins using analytic functions

From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
To: mark.powell2@xxxxxx
Date: Thu, 18 Mar 2010 22:43:06 +0800

> FROM
> tab1,tab2
>
>
>
Um....self join means table "X" joined to table "X"...

Your query doesn't have that....

-- 
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

References:
- rewrite self joins using analytic functions
  - From: hrishy
- RE: rewrite self joins using analytic functions
  - From: Powell, Mark

Other related posts:

» rewrite self joins using analytic functions- hrishy
» RE: rewrite self joins using analytic functions- Powell, Mark
» Re: rewrite self joins using analytic functions - Connor McDonald
» RE: rewrite self joins using analytic functions- hrishy