Re: Making query ONLY_FULL_GROUP_BY compatible

[Wim Roffel]

Thanks, that works.

But now I want to make it a little more complicated. I want a third field - description. Of course I could write

select id_category, max(name) as maxname, max(description) as maxdescription from category_table where id_lang=1 group by id_category order by maxname;

But the problem is that I could then get the name from a different row as the description - what is undesirable. How can I avoid that.