Hierarq SQL

From: Miguel Almeida <jmiguel_at_cet.pt>
Date: Tue, 23 Feb 1999 18:59:58 -0000
Message-ID: <36d2f9e0.0@news.cet.pt>

Can someone help me?

Table HIEA with:

   A                   B
  -------           -------

AB01001 JJ01001
AA01006 AB01001
0119023 AA01006
 .... .......

When i execute:
SELECT A,B FROM HIEA WHERE A NOT IN (SELECT B FROM HIEA) START WITH B='JJ01001' CONNECT BY PRIOR A=B;
Result:

   A                   B


-------            -------

0119023 AA01006

However i want:

   A                   B


-------            -------

0119023 JJ01001

How can i obtain it?

Thanks,
Miguel Received on Tue Feb 23 1999 - 12:59:58 CST