Skip to Content
avatar image
Former Member

Error executing query on HANA database

Hello,

We are trying to run the query mentioned below on a HANA database. However we are getting an error after executing it.

SELECT COL1 FROM TBL1 T1

CROSS JOIN FN_ABC(T1.ID,100000) FN

Error: field or table alias is not allowed as an input of table functions

Is there any way/workaround to make this work?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 17, 2016 at 10:28 PM
    -1

    Try moving the "select col1 from tbl1..." into the table function.

    Best regards

    Chr

    Add comment
    10|10000 characters needed characters exceeded