Oracle Error ORA-25955: all tables must be joined in the where clause

Oracle Error Message

ORA-25955: all tables must be joined in the where clause

Reason for the Error

An attempt to create a join index was made, which failed because one of the tables in the from clause did not appear in the where clause.

Solution

Ensure that the where clause contains all from clause tables.