I am using DatabaseRetrieve Node in my flow to query data from the database. There are three tables in the database and I need to fire a nested query on those tables. Is there any way to do that? or is there any way to configure the DatabaseRetrieve node in such a way that we can fire nested query? My nested query would be something like this:
SELECT * FROM TABLE1 where TABLE1.COL1 IN (SELECT TABLE2.COL1 FROM TABLE2 WHERE TABLE2.COL2='<VALUE>');
Pinned topic How to create nested queries using DatabaseRetrieve Node ?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-17T12:03:33Z at 2012-10-17T12:03:33Z by Muk1234
Muk1234 270005QJJK12 Posts
Re: How to create nested queries using DatabaseRetrieve Node ?2012-10-17T12:03:33ZThis is the accepted answer. This is the accepted answer.Hello All
So far I have figured out a way of doing this. We can use multiple databaseretrieve nodes to achieve nesting of queries.