Database Error Messages

OCI-18640

JOIN TO ONE reached multiple rows joining to "string", resulting in a non-unique join
  • table alias: alias of the table producing multiple rows

Cause

An ON condition or key-derived join condition in the JOIN TO ONE clause produced multiple rows for a row in the child table(s).


Action

Modify the ON condition such that a row in a child table joins to exactly one row in the parent table.