Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-01060

illegal subquery in the HAVING clause

Cause

When a HAVING clause has a subquery, then any references to the tables in the outer query should only reference the tables in the GROUP BY clause.


Action

Correct error in the syntax and rerun the query.