I want to have a alias name of a Table within a SELECT - Statement.
I found nothing about that in the sapdb-docu, but on another page: http://aubit4gl.sourceforge.net/aubit4gldoc/manual/html/sqlconvert.html
TABLE_ALIAS_AS
Insert the word "as" before table alias names in a 'from' clause
eg:
from ..., table1 t1, ... -> from ..., table1 as t1, ...but, when I try :
SELECT * FROM tablename AS aliasname
there comes an Error :
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Syntax error or access violation;-3008 POS(26) Invalid keyword or missing delimiter.
So, is there a way to use Table-alias names in SQL Statements ?
Regards, Danny
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
