Topic
  • 1 reply
  • Latest Post - ‏2012-10-17T12:03:33Z by Muk1234
Muk1234
Muk1234
12 Posts

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

    Re: How to create nested queries using DatabaseRetrieve Node ?

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