Missing definite column name

[Gustavo Comba]

Hi,       I'm issuing the following query:       SELECT FECHA AS CREATETIME, FECHA AS MODIFIEDTIME FROM LECTURASHISTORICAS ORDER BY FECHA     (actually this is only a part of the query, but throws the same error)   And I'm getting the following error:     -5014, "Missing definite column name"     I've searched the web for the error message and I got (http://help.sap.com/saphelp_45b/helpdata/en/67/786af7067411d2a96c00a0c9449261/content.htm): The number of tables specified in a <FROM clause> of the SQL statement is greater than 1. A <COLUMN NAME> without preceding <TABLE SPEC> was used, and this <COLUMN NAME> occurs in more than one of the tables specified in the <FROM clause>.     I think this may be an error on the SQL parser, because it's clear that I don't have more than 1 table names on my "<FROM clause>", and it's clear that there is no ambiguity in the SQL Query, because the field "FECHA" is allways the same and is, obviously, on the "LECTURASHISTORICAS" table.     If I change the query to:     SELECT FECHA AS CREATETIME FROM LECTURASHISTORICAS ORDER BY FECHA     Then there is no problem, but the query is auto-generated by a third-party software, so I can't change anything.     Any idea or suggestion? Is this a bug?         Thanks in advance for your attention,                     Gustavo Comba