0 Replies Latest reply on May 14, 2002 8:59 AM by Ron Jawanda

    Querying Hierarchical Data using CMP

    Ron Jawanda Novice

      I want to be able to use the connect by prior and LEVEL in my sql statement.
      Is this possible in CMP (1.0)
      I am using JBOSS 2.4.4
      I think it isn't but just wanted to ask.
      Thanks
      Ron



      select T$MITM, T$SITM,LEVEL from baan.ttisfc954001 where T$CPRJ='219657'
      and T$ADDN=2
      start with T$MITM=' INJECTION'
      connect by prior T$SITM=T$MITM ;