On trying to convert MySQL query to MsSql query ends in trouble.
Error states that
Column 'books.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
This code sucks
SELECT * FROM books group by books.category_id
does anyone have any ideas?
Thanks in advance!