>

>SELECT Date, DatePart(hour,Date) as Hr, reading
>FROM TABLE1 A
>WHERE Date IN 
>
>(SELECT Min(Date) as date
> FROM TABLE1 B
> WHERE DatePart(hour,A.Date)= DatePart(hour,B.Date) 
> 
>UNION
>
> SELECT Min(Date)as date
> FROM TABLE2 C
> WHERE DatePart(hour,A.Date)= DatePart(hour,C.Date)) 
>

Thanks sir your codes work fine in sqlserver new query window
But I want to create a view from these codes instead of using codes every time.
I shall pickup required data from view.

To do this I put your codes under view like shown in image but it is displaying an error messages

I think there will be use JOIN clause but I am unable to do this.
Please help me to create a view with your codes

Thanks