Re: -No Subject-

Kate Tomchik/IS/SSC/THD@emory.mathcs.emory.edu wrote: :Does anyone know why the following query works in 5.03 but not 7.13? :It appears that "at" is a reserved word in version 7.13. :select * from appl_log at where at.evnt_ts = today This works fine in 7.10.UC1 (on SCO 3.2.4.2) It gives syntax error in 7.12.UC1 (on SCO 5.0.0d) The syntax: select * from appl_log as at where at.evnt_ts = today works in both cases. I have a hunch this is more according to standard SQL these days. Your syntax ought to have worked though, so it would be fine if someone intimate with the internals should explain this. Can we expect more such problems? Luckily we never use this syntax except where we must due to a self join. The SQL will be substantially clearer with full tablenames all the way. However when there is one such problem, may be it pops up in other areas as well? What say ya all? Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company