SELECT Date, DatePart(hour,Date) as Hr, reading FROM TABLE1 A WHERE Date = (SELECT Min(Date) as date FROM TABLE1 B WHERE DatePart(hour,A.Date)= DatePart(hour,B.Date) union all SELECT Min(Date)as date FROM TABLE2 C WHERE DatePart(hour,A.Date)= DatePart(hour,C.Date))but I am facing this error message
SELECT Date, DatePart(hour,Date) as Hr, reading FROM TABLE1 A WHERE Date = (SELECT Min(Date) as date FROM TABLE1 B WHERE DatePart(hour,A.Date)= DatePart(hour,B.Date) )Please