这样啊.
比如:
set rs1=server.createobject("adodb.recordset")
sql1="select * from 表1"
rs1.open sql1,conntmp,1,1
for n=1 to rs1.recordcount
set rs2=server.createobject("adodb.recordset")
sql2="select * from 表2 where 字段='"&rs1("字段")&"'"
rs2.open sql2,conntmp,1,1
......显示内容可以根据需要分别调用rs1(字段)和rs2(字段)
rs1.movenext
next