Again how to build a query on another query 1

[delorfra]

I have already posted this before but I am trying again since I really need it.

I want to build a query and then use it in another query (Oracle database).

sort of :
set myconn = server.createobject("ADODB.Connection&quot
myconn.connectionstring = ".."
set myset = server.createobject("ADODB.recordset&quot
mysql = "Select ..."
myset.open mysql, myconn

and then I want to refer to this first query in another sql statement to build another query.
mysql2 = "select .."
myset2.open mysql2, myconn

How can I do that ??
In Access, instead of opening the first query, i would create a querydef and then use the DAO querydef name to refer to it in the sql statement of the second query. But how I can I do the same in ADO/ASP.

Thanks

 

[Swany]

I think you are trying to create a hierarchial relationship between two recordsets.

This link has more info about that.

http://www.insteptech.com/hierarchical.htm

.
.. Eat, think and be merry .
... ....................... .