PROTECTED]
Cc: mysql@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
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 not sure how to do this in bulk.
Thanks.
Hi,
I hope this finds itself as an answer to my last post. I'm new to this email
message format of lists.
It turns out that the problem with the join was that I had a column being
selected that I removed from my posting example for brevity which was
causing the select to fail. The extra c
Hi,
I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table to 4 other tables. The query I have so far is bel
