start with...connect by层次查询不能同时用于多张表 A join operation was specified with a CONNECT BY clause. If a CONNECT BY clause is used in a SELECT statement for a tree-structured query, only one table may be referenced in the query.
ORA-01437:cannot have join with CONNECT BY Cause: A join operation was specified with a CONNECT BY clause. If a CONNECT BY clause is used in a SELECT statement for a tree-structured query, only one table may be referenced in the query. Action: Remove either the CONNECT BY clause or the join operation from the SQL statement.
A join operation was specified with a CONNECT BY clause. If a CONNECT BY clause is used in a SELECT statement for a tree-structured query, only one table may be referenced in the query.
Cause: A join operation was specified with a CONNECT BY clause.
If a CONNECT BY clause is used in a SELECT statement for a tree-structured query,
only one table may be referenced in the query.
Action: Remove either the CONNECT BY clause or the join operation from the SQL statement.