[Solved]output from a sql query is input to another sql query

Hi,

Trying to implement a workflow in knime where the output from one of the sql query is input to another sql query

The first query is

select empID,empName from empolyee table

The second query will be

select empProfile from profile where empID = $empID

I used the database reader to execute the first query i got all the empIDs now i have to run another the second query in where the input is empID i got in first query

Can anyone suggest how to achieve this using knime

 

Regards,

Amarendra

 

 

Use table Row to Variable node and submit empID to the second reader node as variable.

thanks for the hint i used the tabl row to variable loop start and it worked