Re: Error with max and group by

e max function are apparently being mixed up. On Sat, Jun 21, 2008 at 12:00 AM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl <[EMAIL PROTECTED]> wrote: > > I want to get back only the most recent entry for each person and I don't > &

Error with max and group by

Hi, My sql is rusty but I'm trying to solve a problem and I'm getting a result that does not make sense. The table is mysql> select * from cust_full; +---+-+--++ | name | item_id | location | acq_date | +---+-+--++ | Jim |