Oracle Error QSM-02035: no filter conditions are present in the HAVING clause

Oracle Error Message

QSM-02035: no filter conditions are present in the HAVING clause

Reason for the Error

The capability in question is not supported when the materialized view includes no filter condition in the HAVING clause.

Solution

Re-phrase the query to include a join.