Topic
IC4NOTICE: 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.
1 reply Latest Post - ‏2012-10-17T12:03:33Z by Muk1234
Muk1234
Muk1234
12 Posts
ACCEPTED ANSWER

Pinned topic How to create nested queries using DatabaseRetrieve Node ?

‏2012-10-16T10:20:32Z |
Hello
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>');
Updated on 2012-10-17T12:03:33Z at 2012-10-17T12:03:33Z by Muk1234
  • Muk1234
    Muk1234
    12 Posts
    ACCEPTED ANSWER

    Re: How to create nested queries using DatabaseRetrieve Node ?

    ‏2012-10-17T12:03:33Z  in response to Muk1234
    Hello All
    So far I have figured out a way of doing this. We can use multiple databaseretrieve nodes to achieve nesting of queries.