SELECT * FROM dbo.Ys_CloseOPen AS a INNER JOIN
dbo.Ysmx_CloseOpen AS b ON a.TaskID = b.TaskID
where a.iyear = '2012' and a.imonth = '2' and
a.taskid = (select max(TaskID) from dbo.Ys_CloseOPen where iyear='2012' and imonth='2')
SELECT b.CompanyID as CompayID, a.iYear, a.iMonth,b.Itemcode as ItemName, b.AfterStatus
FROM dbo.Ys_CloseOPen AS a INNER JOIN
dbo.Ysmx_CloseOpen AS b ON a.TaskID = b.TaskID
where a.Flag = 1
group by a.iyear, a.imonth ,a.taskid, a.Flag,
b.CompanyID , a.iYear, a.iMonth,b.Itemcode , b.AfterStatus having a.taskid in ---每一个类型的最大id值
(select max(taskid) from Ys_CloseOPen c
group by c.iyear, c.imonth )