On Wed, Feb 19, Wiktor Wodecki wrote:
On Tue, Feb 18, 2003 at 11:49:56PM +0100, Martin Edenhofer wrote:
SELECT count(*) FROM ticket as st, queue as sq, personal_queues as suq, ticket_state tsd, ticket_lock_type slt ...
the keyword "as" is not accepted by SAPDB and its right. IMHO is this keyword not allowed here. Is it working if you use the same statement without "as"?
SELECT bla FROM relation1 AS rel1 is a valid SQL statement since SQL92. I'm suprised SAPDB doesn't support this...it does, I found the aproperiate entry in die SAB DB LIBRARY (http://www.sapdb.org/7.4/htmhelp/e2/55683ab81fd846e10000000a11402f/frameset...., see Reference Manual -> Basic Elements -> Names -> Reference Name). Wolfgang, could you please check if this works for you and provide us a working SABDB SQL example? We could see if we can lay low and keep it generic or if we have to write specific modules for specific databases
Maybe that is fare to simple, but did you try "AS" in stead of "as" in the statement? Maybe SAPDB is stricter with this. Just an idea. take care Stefan Wintermeyer -- Stefan Wintermeyer You'll be getting more than just a lawyer, Mr. Simpson. You'll also be getting this exquisite faux pearl necklace, a $99 value, as our gift to you. (Lionel Hutz) "The Simpsons"