SQL Reserved word error

[emorris1000]

Getting the "This Select statement includes a reserved word or argument name that is mispelled or missing" error on a table, I think I know what is causing it but wanted to be sure.

The following works

Select  PolyID, Ethflow, "" as H2RatGC, ""as C6RatGC
From Trundata
Where PolyID = "UT-00409-024"
Union
Select  PolyID, "" as Ethflow,  H2RatGC, C6RatGC
From [GC Data]
Where PolyID = "UT-00409-024"

However this throws an error:

Select  PolyID, Time, Ethflow, "" as H2RatGC, ""as C6RatGC
From Trundata
Where PolyID = "UT-00409-024"
Union
Select  PolyID, RunTime as Time, "" as Ethflow,  H2RatGC, C6RatGC
From [GC Data]
Where PolyID = "UT-00409-024"

My guess is that "Time" is the reserved word. If so I am a bit surprised because it exists in a bunch of other queries.

 

[boblarson]

Yes, TIME is a reserved word. You can get it to work for yourself though if you put square brackets around it:

SELECT PolyID, [Time], EthFlow...etc.


But best to not use reserved words.

 

[emorris1000]

Yeah, it's on my list of things to do in cleanup mode. Got it working now thx!