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

ERRORno filter conditions are present in the HAVING clause
CAUSEThe capability in question is not supported when the materialized view includes no filter condition in the HAVING clause.
ACTIONRe-phrase the query to include a join.