select Stcd,convert(varchar(10),tm,120) ym,tm,GWL into DaYtemp from GW_WLH_R select Stcd,ym,max(GWL)MaxGWL,min(GWL) MinGWL,avg(convert(decimal(6, 2),GWL)) avgdate into DaYtemp1 from DaYtemp group by Stcd,ym order by Stcd SELECT a.STCD, a.maxGWL, a.avgGWL, b.tm AS MaxTime, a.ym FROM dbo.daytemp AS b INNER JOIN dbo.daytemp1 AS a ON b.STCD = a.STCD WHERE (b.tm = (SELECT MAX(tm) AS Expr1 FROM dbo.daytemp WHERE (GWL = a.maxGWL) AND (STCD = a.STCD) AND (ym = a.ym)))