Hello, 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.htm, 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 (we could improve a lot when dropping some of the mysql compatibility for postgres *g*). In the longterm we might have to so anyway, so why not for 1.1...? -- Regards, Wiktor Wodecki
msg00074/pgp00000.pgp
Description: PGP signature
