Oracle Error QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query

Oracle Error Message

QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query

Reason for the Error

All lossy joins in the equivalence must be present in the query for query rewrite to occur.

Solution

None