SELECT hrs,Max(reading)as reading FROM bin1 WHERE (CONVERT(VARCHAR(10), date, 103) = CONVERT(VARCHAR(10), GETDATE(), 103)) AND (hrs IS NOT NULL) and updown=0 and tik is null group by hrs union SELECT hrs,max(reading)as reading FROM bin1_empty WHERE (CONVERT(VARCHAR(10), date, 103) = CONVERT(VARCHAR(10), GETDATE(), 103)) AND (hrs IS NOT NULL) group by hrs order by hrsIt display following result