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>');
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-10-17T12:03:33Z by Muk1234
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