orderok.asp?id=20130710008地址查询两表中的内容表1 orderid orderid title stores表2 table相同字段 is name stores 请问查询表1 orderid为20130710008的值,并且stores字段来查询表2关联的数据 SQL语句要怎么写?谢谢!
<%
set rs1 = server.createobject("adodb.recordset")
set rs2 = server.createobject("adodb.recordset")
rs1.open"select * from biao1 order by id desc",conn,1,1
do while not rs1.eof
rs2.open"select * from biao2 where 字段 = "&rs1("字段")&"",conn,1,1
'你想做的事情
rs2.close
rs1.movenext
loop
rs1.close