>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)) >>
>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) ) >>