DB Query Reader Issue

I have a complex query with multiple statements using temporary table. I make the last statement to a select statement from the temporary table.lt doesn’t work. It works well in my standalone query tool. Query like:
select * into temp table tmp_x from abc.table_x;
select * from tmp_x;

Error message:
ERROR DB Query Reader 3:12 Execute failed: No results were returned by the query.
Any ideas where is the issue?

Hi @bgwang518 , and welcome to the KNIME community.

Without seeing your actual query and details of the type of database you are using, it is difficult to be certain what the problem is, but I wonder if removing the final ; after the last statement would resolve the issue, as per the following post…

4 Likes

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