Description:
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.
ORA-00900 to ORA-01499 cannot have join with connect by, caused by: java.sql.sqlexception: ora-01437: cannot have join with connect by, connecting servlet ora-00900, j, java.sql.sqlexception: ora-01437: cannot have join with connect by, lrm-00118: syntax error at '=' at the end of input, ora-00900 "join", ora-00900 connect, ora-00900 connect by, ora-00900 connect by prior, ora-00900 start with connect, ora-00900 with statement and connect by, ora-01437 cannot have join, ora-01437 error, ora-01437 solution
Remove either the CONNECT BY clause or the join operation from the SQL statement.