Connect Query

 Hi !

    For one o this reasons, I need to retrieve information with a query, from some tables, and organize this information with a connect by.

  Something like this:

select org_cod, oro_father
from org, oro
where oro_cod = org_cod
start with oro_father is null CONNECT BY PRIOR oro_cod=oro_father;

    but I get a : ORA-01437: cannot have join with CONNECT BY;

Is there any work around to solve this whit out a cursor ?

TIA. Jordi Bellver Received on Thu Oct 22 1998 - 00:00:00 CDT