Skip to Content
0

Error executing query on HANA database

Dec 07, 2016 at 01:49 PM

199

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Christoph Gilde
Dec 17, 2016 at 10:28 PM
-1

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

Best regards

Chr

Share
10 |10000 characters needed characters left characters exceeded