DB Table Selector, custom query: With etc.


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,

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


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.