Have you tried this:
select tab2.col1, tab2.col2, x.col1, x.col2
from
(select column1 col1,
column2 col2
from tab2
where ( your independent conditions here, can't refer to outer query here)
) x,
tab2
where x.col1 = tab2.col1 [etc...]
Is that what you are looking for?
HTH
Lisa Koivu
Clumsy Ninja-ette
Ft. Lauderdale, FL, USA
-----Original Message-----
From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L
Subject: QUERY HELP
Dear Guru's,
How can i refer the previous record detail(s), when oracle fetchs the current row details?.
sql> SELECT rownum rnum, empno eno, ename FROM EMP;
RNUM��� ENO���� ENAME
----------------------------------
1������ 7369��� SMITH
2������ 7499��� ALLEN
3������ 7521��� WARD
4������ 7566��� JONES
7������ 7782��� CLARK
8������ 7788��� SCOTT
10����� 7844��� TURNER
In the above, can i able to put * mark in record 7 and 10, since before these two records, some records are missing.
Is this possible to do this by query. I need this in reports.
Basically my question is,
How can i refer the previous row detail(s), when oracle fetchs the current row details?.
Thanks in adv.
REgards,
Nirmal.
