Oracle Error QSM-02009: non-inner join

Oracle Error Message

QSM-02009: non-inner join

Reason for the Error

The capability in question is only supported with inner joins.

Solution

Re-phrase the query using an inner join. Remove any outer joins.