Oracle Error QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query

Oracle Error Message

QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query

Reason for the Error

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

Solution

None