Struggling with a GROUP BY count
with this query,
i'm getting the error,
which i'm a bit confused on? i'm using the
id
col is in the aggregate function already3 Replies
Are you sure that
getTableColumns
doesn't also include song_history.id
?Not just that, any column other that the one in the aggreagate function need to be in the group by clause
Usuully, just adding the PK column works, in that case it would be adding
songHistory.id
to group by