How do you determine "most recent"? Is it based on the highest ID number for a person or some datetime value you didn't show us?
This is another form of the groupwise maximum problem described here: http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html If after reading the docs, you still can't make it work. Come back to the list with your attempt and tell us what it did and didn't provide for you. Someone will be more than happy to help. 'Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> wrote on 04/29/2005 10:52:34 AM: > > > If I have a table with fields > > ID, NAME, VALUE > > and they may be populated like > > 1, SHAWN, APPLE > 2, TOM, BANANA > 3, SHAWN, BANANA > 4, JACK, GRAPES > 5, TOM, APPLE > 6, SHAWN, GRAPES > > and I want to query all records showing only the most recent records for > each person.... > > > > > Any thoughts? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
