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

Oracle Error Message

QSM-02034: no joins are present in the HAVING clause

Reason for the Error

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

Solution

Re-phrase the query to include a join.