[EMAIL PROTECTED] wrote: > I've got a serious problem with table aliases at JOIN. > > For example, the query > SELECT t175.dfd, t178.literal FROM t175 join t178 as proba ON > t178.fromobjectid = t175.objectid; > > results in > > FAILURE: [-5015] (at 55): Missing keyword:ON > > It doesn't work this way. Is there a magic switch, which > could make it work? > What could I do get around this problem without rewriting all > sql queries? > We've got a lot of them. :(
Sorry, bad news for you. The syntax with 'as' is no valid alias or reference name syntax for SAP DB. You have to write the alias directly behind the table name, see http://www.sapdb.org/7.4/htmhelp/a5/298aa43dae11d3a98200a0c9449261/frameset.htm for more information. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
