This query runs on my pc but not on my laptop

  • Thread starter Thread starter GWB
  • Start date Start date
G

GWB

SELECT sum(AvgOfCurrentSteamFlow)

FROM [SELECT dbo_Boiler_Steam_Production.ReadingDate AS Expr1,
Hour([ReadingTime]) AS Expr3,
Avg(dbo_Boiler_Steam_Production.CurrentSteamFlow) AS AvgOfCurrentSteamFlow

FROM dbo_Boiler_Steam_Production

GROUP BY dbo_Boiler_Steam_Production.ReadingDate, Hour([ReadingTime])

HAVING (((Year([ReadingDate]))=[Select Year]))]. AS [%$##@_Alias];


Failure message is: invalid bracketing of name 'SELECT........
 
Back
Top