RE: Stupid GROUP BY question

2009-09-25 Thread Gavin Towey
Commonly refered to as a "groupwise max" http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html http://jan.kneschke.de/projects/mysql/groupwise-max/ Regards, Gavin Towey -Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: Friday, Septem

Re: Stupid GROUP BY question

2009-09-25 Thread Peter Brawley
Jerry, I want to find the newest note (if any) for each customer. See "Within-group aggregates" at http://www.artfulsoftware.com/infotree/queries.php PB - Jerry Schwartz wrote: It must be too late in the week... Suppose table Cust has