Hi all
I would like to count the green eye kittens,
This HQL fetch query works fine:
but when i add the count(*)
I got this Exception (MSSQL):
Column 'cat.kittens' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
What am I doing wrong?
Thank you!