Thanks Tobia, I'm working with MySQL too. Maybe I should have a look at their docu.
-Stefan 2007/2/22, Tobia <[EMAIL PROTECTED]>:
Stefan Hübner wrote: > Dev at weitling <[EMAIL PROTECTED]>: > > select a.name as aName, a.id as aID, b.id as bID, b.name as bName > > no, disappointingly enough, that doesn't work. It works here, using MySQL. Maybe it depends on the SQL engine? If you can't get the "as" keyword to work, you can always use some XSLT to tell them apart or to rename them: <xsl:template match="sql:rowset/sql:row/sql:id[position() = 1]"> <xsl:template match="sql:rowset/sql:row/sql:id[position() = 2]"> Tobia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
