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

[unbeliever]

I have done some further reading and the result is as follows.

Code:

Dim oConn
Dim oRecSet
Dim strQuery
Set oConn = CreateObject("ADODB.Connection")
Set oRecSet = CreateObject("ADODB.Recordset")
strQuery = "Select * from somewhere where location = 'Moon'"
oConn.Open "Driver={Microsoft ODBC for Oracle};Server=myserver.com;Uid=user;Pwd=pwd;"
oRecSet.Open strQuery, objConn

I need to select a value for a column 'Mountain' for the one record that is generated for this query and then move it to QTP Data Table. Let's call this value BigX

Afterwards I need to get results of query "Select * from elsewhere where population = 'BigX'". BigX here is the value from QTP Data Table, not DB, in other words variable dependent on previous query.

Can you please provide me with some sample code for this case?