Previous Topic: -75 - CANNOT USE COLUMN FUNCTIONS WITH NO GROUP BY CLAUSENext Topic: -79 - UPDATE/DELETE WHERE CURRENT OF cursorname ON READ ONLY CURSOR


-76 - colName IN HAVING NOT GROUP COLUMN OR COLUMN FUNCTION ARGUMENT

Reason:

A column can only be referenced in the HAVING clause if it is also in the GROUP BY clause, or if it is an argument of a column function.

The SQLSTATE that equates to this SQL return code is 42803.

Action:

Either remove the column reference, add it to the GROUP BY clause, or make it an argument of a column function.