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.htm, >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
msg00078/pgp00000.pgp
Description: PGP signature
