DB Table Selector, custom query: With etc.

#1

Hello,

sorry for asking, but how can I use the with statement in a custom sql query?
I know how to use it in SQL, that’s not the problem.
My problem is the node converting the custom sql into: select * from ( <given_sql_statement> ).

I just don’t know the correct knime syntax, if there is one.

Can anyone help me? (Legacy nodes don’t have that problem, I know)

All the best,
Torsten

0 Likes

#2

I would suggest using your DB connector with the DB Query Reader node then you can just use your normal SQL script to read the data

2 Likes