RE: group by issue...??

[Paul DuBois]

At 16:51 -0700 9/10/04, bruce wrote:
>paul....
>
>forgive me for being a neophyte!!! but i have no idea how what you said
>helps me get to how i can actually get a grouping....
>
>is there anyway to get a grouping... is there some other way to accomplish
>this..?
>
>am i totally lost!????

If you just want to sort things, you can use ORDER BY rather than GROUP BY.

>
>thanks..
>
>ps. i'm really trying to figure out how to get the last record from a
>select/join without having to go through multiple queries/selects...

Sort in reverse and use LIMIT 1?

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com