Message Oracle QSM-02007 - multiple instances of the same table or view

ERRORmultiple instances of the same table or view
CAUSEThe capability in question is not supported when the same table or view occurs more than once in the FROM list.
ACTIONRe-phrase the query to avoid multiple instances of the same table. For instance,