Hi,
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).
This is the standard reference, which is implied if you give an alias right behind the table. The keyword AS is only allowed for values that need to be aliased. Example: select count(name) as cn from table1 tab1; For the table reference the keyword AS is not allowed, and IMHO not defined in SQL92. BTW: Hi to the OTRS team ;-) greets, Daniel Rahn -- SuSE Linux AG | phone: +49 (0) 911 74053 351 Enterprise Support Services | fax: +49 (0) 911 74053 674 Deutschherrnstr. 15-19 | http://www.suse.de/en/support 90443 Nuernberg | GERMANY