Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-01437

cannot have join with CONNECT BY

Cause

A join operation was specified with a CONNECT BY clause. If a CONNECT BY clause was 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.