How do I efficiently handle ADO record-set chains/cascades?

[zensunni]

OK,

Say I have two tables and for every record I list from the first table, I need to grab some records from the second table like so:

==================================================
SQLQuery = "Select * From Table1"
Set recordset = objConn.Execute(SQLQuery)

Do Until recordset.EOF

Response.Write recordset("Name")
SQLQuery2 = "Select * From Table2 where likes = " & recordset("division") "<br>"
Set recordset2 = objConn.Execute(SQLQuery)
Do Until recordset2.EOF
Response.Write "Division: " & recordset2("Name") & "<br>"
Response.Write "Number: " & recordset2("Number") & "<br>"
Response.Write "Description: " & recordset2("Description") & "<br>"
Loop
Response.Write "<br><br>"
Loop
==================================================

This is fine for small applications, but what if I'm reporting for over a thousand people? Is there a more efficient way of doing this?