From: Date: December 3 2003 10:07am
Subject: Join only the latest entry...
List-Archive: http://lists.mysql.com/mysql/154923
Message-Id: <3FCDA7D0.8070305@pilotmedia.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hello there,

I have a table including information about my projects, the structure 
has each id and name. Then I have another table including status 
information of each project: entryid, projectid, status and timestamp.

Is there any possibility to fetch a list of projects with the most 
recent status by one query? I can do it of course by two different 
queries, but I don't find it as very good solution.

Thanks,
Ville