SQL statement wrong (over and as)

SQL statement wrong (over and as)

  
Does anyone know what to change to a sql statement as your statement use “over” or “as ” for version 9.
Rob Engler (Certimark) wrote:
Does anyone know what to change to a sql statement as your statement use “over” or “as ” for version 9.
 Can you please elaborate the issue or provide the sample query or error which is coming?
 
Hi Guys

I would suggest it was something like the attached oml file from the online course


I unhappily ignored the warning...too many things to learn.. so have not researched it.


The SQL editor and its parser are pretty good, but they handle only a subset of SQL, and are especially ignorant of vender-specific extensions. If the parser encounters something it doens't understand, it'll complain (i.e. show a warning). This doesn't mean the query isn't valid, it just means the parser is confused. It'll send the query to the database anyhow.