Oracle Error ORA-30400: identical JOIN KEY clauses

Oracle Error Message

ORA-30400: identical JOIN KEY clauses

Reason for the Error

Two JOIN KEY clauses with identical child keys and parent levels were specified.

Solution

Eliminate the redundant JOIN KEY clause.