>
> OH, well you had better argue that out with MySQL because it says you
> do!
>
> If you are not happy with the syntax supplied by the MySQL product and
> SQL, you had better write your own RDBMS and your own SQL standard!
>



ok, I didn't want to start a fight, sorry for saying what I said, it was
my ignorance speaking for me. I was just wondering -since my query is
just working- if that group-by is something that can alter the way the
results are sorted by (the entire query I did not post ends with an
order by desc)