[thelist] SQL Query : using Group By and Order By together

[rudy]

> I am afraid you've mistaken my goal, it is not to have several times the
> same logo, but to GROUP all entries featuring the aplogo into ONE row.

ah

you mean, instead of

   aplogoA   date1
   aplogoA   date2
   aplogoA   date3
   aplogoB   date7
   aplogoB   date8

you want

   aplogoA   date1  date2  date3
   aplogoB   date7  date 8

that's very very hard to with sql

you need to use the query i gave you (without GROUP BY) and "flatten" the
results (that's a technical term) using php


> ps: you said: "what GROUP BY does is create one row for each
> value of the group" do you mean, as I think _group by_ behaves, it
> creates one row including all values of the group ?

no, it creates one row for each group and some *aggregate* information
about the group

using the example data above,

    select aplogo, count(*)
      from table
       group by aplogo

gives

    aplogoA  3
    aplogoB  2

another example,

   select aplogo, max(apdate)
      from table
       group by aplogo

gives

   aplogoA  date3
   aplogoB  date8

see?  one row per group

rudy