SET NOCOUNT ON
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
SET @StartDate = DateAdd(mi,-5,GetDate())
SET @EndDate = GetDate()
SET NOCOUNT OFF

SELECT  T1.DateTime, T1.TimeConvert, T1.PSM,T2.COUNTS,T2.Interval FROM
(SELECT  temp1.DateTime, temp1.PSM, temp2.TimeConvert 
FROM 
(SELECT History.TagName, DateTime, Value as PSM, StartDateTime
 FROM History
 WHERE History.TagName IN ( 'GZU_11.ZAMERPSM')

 AND wwRetrievalMode = 'Cyclic'
 AND wwCycleCount = 100
 AND wwQualityRule = 'Extended'
 AND wwVersion = 'Latest'
 AND DateTime >= @StartDate
 AND DateTime <= @EndDate
) temp1

Inner join

(SELECT History.TagName, DateTime, vValue as TimeConvert, StartDateTime
 FROM History
 WHERE History.TagName IN ( 'GZU_11.ZAMERTIMECONVERT')

 AND wwRetrievalMode = 'Cyclic'
 AND wwCycleCount = 100
 AND wwQualityRule = 'Extended'
 AND wwVersion = 'Latest'
 AND DateTime >= @StartDate
 AND DateTime <= @EndDate
) temp2
ON temp1.DateTime=temp2.DateTime
WHERE temp1.StartDateTime >= @StartDate) T1

inner join

(SELECT  temp1.DateTime, temp1.COUNTS, temp2.Interval 
FROM 
(SELECT History.TagName, DateTime, Value as COUNTS, StartDateTime
 FROM History
 WHERE History.TagName IN ( 'GZU_11.ZAMERCOUNT')

 AND wwRetrievalMode = 'Cyclic'
 AND wwCycleCount = 100
 AND wwQualityRule = 'Extended'
 AND wwVersion = 'Latest'
 AND DateTime >= @StartDate
 AND DateTime <= @EndDate
) temp1

Inner join

(SELECT History.TagName, DateTime, Value as Interval, StartDateTime
 FROM History
 WHERE History.TagName IN ( 'GZU_11.ZAMERINTERVAL')

 AND wwRetrievalMode = 'Cyclic'
 AND wwCycleCount = 100
 AND wwQualityRule = 'Extended'
 AND wwVersion = 'Latest'
 AND DateTime >= @StartDate
 AND DateTime <= @EndDate
) temp2
ON temp1.DateTime=temp2.DateTime
WHERE temp1.StartDateTime >= @StartDate) T2
ON T1.DateTime=T2.DateTime