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

From: Jay <no_at_spam.com>
Date: Thu, 11 Sep 2003 12:41:56 -0400
Message-ID: <bjq8ev$1e5$1@msunews.cl.msu.edu>

Thank you guys,
Yes I'm using 8i.

-Jay

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0309101542.3c456e7_at_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 Thu Sep 11 2003 - 11:41:56 CDT