日期查询问题

OJX_01

分两次查询
1.查同一ID的最早日期//查询1
SELECT First(Sheet1.計画日) AS 計画日之第一条记录, Sheet1.ID
FROM Sheet1
GROUP BY Sheet1.ID;
2.按ID和最早日期再查出记录//查询2
SELECT 查询1.計画日之第一条记录, 查询1.ID, Sheet1.TF, Sheet1.TL, Sheet1.ST, Sheet1.計画数
FROM 查询1 INNER JOIN Sheet1 ON (Sheet1.ID = 查询1.ID) AND (查询1.計画日之第一条记录 = Sheet1.計画日);