SQL Codes › SQL Return Codes -1 through -999 › -73 - SELECTED COLUMNS MUST BE IN THE GROUP BY CLAUSE

-73 - SELECTED COLUMNS MUST BE IN THE GROUP BY CLAUSE

Reason:

The SELECT list or the HAVING clause contains a column that is not contained in the GROUP BY clause.

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

Action:

Either remove the column in question from the SELECT list or HAVING clause, or add it to the GROUP BY clause.