From: Date: September 11 2004 2:00am Subject: RE: group by issue...?? List-Archive: http://lists.mysql.com/mysql/172443 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" ; format="flowed" 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