SQL Codes › SQL Return Codes -1 through -999 › -24 - VIEWS CONTAINING FUNCTIONS OR GROUP BY CANNOT BE JOINED

-24 - VIEWS CONTAINING FUNCTIONS OR GROUP BY CANNOT BE JOINED

Reason:

You attempted to execute a join involving a view that contains a GROUP BY clause, column functions, or both.

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

Action:

Change the join to reference the base table or view on which the offending view was defined, or create the desired view without using GROUP BY or column functions and use this view in the join. If the view being referenced does not include a GROUP BY or column function, some view that is either directly or indirectly referenced by this view is responsible.