If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Start With Connect By Prior (ora-01437)

Hi there,

I just recently discovered this great bit of code but have now come across a problem. I'm working with Maximo 4.1.1 with a Oracle 8.1.7 database version and I'm using TOAD for my database queries. Here's my problem.

Which is so fantastic beyond my wildest dreams. It's exactly how I want this set of data to look. Now, however, I need to add information from another table (that has a PMNUM column that can be used for reference), and it has a JPNUM column that I want included into my select.

This table also can have duplicate PMNUM with different JPNUM and I want that to be shown in my select as well. I tried simply adding another table reference to my script only to get an ORA-01437: cannot have join with CONNECT BY error. I tried unions and sub selects but only to have the order as above ruined.