Message Oracle QSM-02034 - no joins are present in the HAVING clause

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