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...., 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