Jens Stier wrote:
> I have table "tblstueckliste" and in this table I have a
> column hauptid
> which references to tblstueckliste.id
>
> if i do the query
>
>
> select
> tblstueckliste.id,
> tblstueckliste_2.id as id2
> from tblstueckliste, tblstueckliste as tblstueckliste_2
> where tblstueckliste.hauptid=tblstueckliste_2.id
>
>
> i get the error "invalid keyword or missing delimiter".
>
>
Remove the "as" in the from clause.
Your select should look like this
select
tblstueckliste.id,
tblstueckliste_2.id as id2
from tblstueckliste, tblstueckliste tblstueckliste_2
where tblstueckliste.hauptid=tblstueckliste_2.id
For more information about the syntax of the from clause
see http://www.sapdb.org/htmhelp/a5/298aa43dae11d3a98200a0c9449261/frameset.htm
Kind regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
