获得每个项目的前1条记录

Project- ID,Name
ProjectProgress - ID,ProjectID,ProgressID, Date

ProjectName, ProgressID

SELECT ProjectID, Max([Date]) AS MaxOfDate
FROM ProjectProgress
GROUP BY ProjectID;