ORA-01437: cannot have join with CONNECT BY

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 Received on Wed Sep 10 2003 - 12:51:53 CDT