22,209
社区成员
发帖
与我相关
我的任务
分享
TRANSFORM Max(iif(isnull(b.ProjectID),null,a.CurrentWorking)) AS EventContentOfMax
SELECT a.PersonName
FROM Tasks AS a LEFT JOIN [select ProjectID,min(cdate(TaskDate)) as m_TaskDate from Tasks where cdate(TaskDate)>Now group by ProjectID]. AS b ON (cdate(a.TaskDate)=b.m_TaskDate) AND (a.ProjectID=b.ProjectID)
GROUP BY a.PersonName
PIVOT a.ProjectID
最好给出完整的表结构,测试数据,计算方法和正确结果.