Join only the latest entry...

[Ville Mattila]

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