set rs1=Server.CreateObject("ADODB.RecordSet") set rs2=Server.CreateObject("ADODB.RecordSet") sql1="select * from A "rs1.open sql1,conn,1,1do while not rs1.eof()
a_value=rs1("a表字段名")
sql2="select * from B where b表字段=a_value"
rs2.open sql2,conn,1,1
if rs2.recordcount>0 then
b_value=rs2("b表某个字段")
...
|