Re: ORA-01437: cannot have join with CONNECT BY

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Sep 2003 16:42:17 -0700
Message-ID: <2687bb95.0309101542.3c456e7@posting.google.com>

"Jay" <no_at_spam.com> wrote in message news:<bjno67$m9h$1_at_msunews.cl.msu.edu>...
> Can I use "connect by" in view?
> The view is created from joining 2 tables.
>
>
> I was trying
>
> SELECT col1
> FROM view1
> START WITH col1= 45034
> CONNECT BY PRIOR col2= col1;
>
> and getting
>
> ORA-01437: cannot have join with CONNECT BY
>
> Thanks.
> -Jay

Jay, what version of Oracle are you using? I believe that the connect by clause cannot be used in conjuction with a join until version 9.

HTH -- Mark D Powell -- Received on Wed Sep 10 2003 - 18:42:17 CDT