SQL Codes › SQL Return Codes -1 through -999 › -27 - CANNOT USE GROUP BY IN QUERY THAT REFERENCES A GROUPED VIEW

-27 - CANNOT USE GROUP BY IN QUERY THAT REFERENCES A GROUPED VIEW

Reason:

You executed a query containing a GROUP BY against a view containing a GROUP BY.

The SQLSTATE that equates to this SQL return code is 0AS01.

Action:

Remove the GROUP BY from the query or change the query to reference the base table or view on which the offending view is defined. The offending view may be a view that is directly or indirectly referenced by the view that the query referenced.