optik - 2:55 pm on Sep 5, 2010 (gmt 0) [edited by: optik at 3:48 pm (utc) on Sep 5, 2010]
I'm selecting some results using GROUP BY which are order by one field, that works fine but I then need that result order a second time by another field.
so GROUP BY inventory_code ORDER BY variation_number DESC
this gives me one result for each unique inventory code and the first variation of that inventory item is selected.
What I now need is for all the result for every inventory to be sorted alphabetically by a third field, called title.
[edited by: optik at 3:48 pm (utc) on Sep 5, 2010]