Re: Problem with self-join-relationship

2007-08-20 Thread Mike Kienenberger
I don't know if this is related to your issue, but as an FYI you might want to read through this thread. http://mail-archives.apache.org/mod_mbox/cayenne-user/200706.mbox/[EMAIL PROTECTED] On 8/20/07, Jens Mayer <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to build a tree-like structure base

Problem with self-join-relationship

2007-08-20 Thread Jens Mayer
Hi, I'm trying to build a tree-like structure based on data in my db. My table TMP_TRANSEDIT has a relationship to itself: TMPTRANSEDIT_ID NUMBER(10) is the PK ... and TMPTRANSEDIT_TMPTRANSEDIT_ID NUMBER(10) is used for the relationship to the parent. The tabledata is inserted by two querie