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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
