SQL quering - how to use results of one query in the following one

[Saket]

you can explore more on using adodb objects and get the query results in recordset, that will definitely help you.
I have listed a peice of code here,

Code:

Set ConObj = CreateObject("ADODB.Connection")
     ConObj.Provider = "MSDAORA.1"
     ConObj.Properties("Data Source").Value = Service name
   ConObj.Properties("User ID").Value = UserName

    ConObj.Properties("Password").Value = Password
  
    ConObj.Open

   Set RecObj = CreateObject("ADODB.Recordset")

RecObj.Open <<Your SQL query>>ConObj,adLockPessimistic

Hopefully we will have a series of tutorial Posts on the same topic, soon at http://www.learnqtp.com
register you mail there to receive the notification