Re: Selecting the most recent entry for each object.

2008-03-20 Thread Baron Schwartz
Hi, On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett [EMAIL PROTECTED] wrote: Hi, I have a load of reviews in a table and, for each person I want to pull out the most recent review. So, if I wanted to do this for a single person I would order by date desc and use limit 1. But I'm

RE: Selecting the most recent entry for each object.

2008-03-20 Thread Edward Corbett
@lists.mysql.com Subject: Re: Selecting the most recent entry for each object. Hi, On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett [EMAIL PROTECTED] wrote: Hi, I have a load of reviews in a table and, for each person I want to pull out the most recent review. So, if I wanted to do