那样写:
set rs=conn.execute("select * from Books")
while not rs.eof
rs2=conn.execute("select * from Authrs where AuthorID="&rs("AuthorID"))
Response.write rs("Title")&">>"&rs2("Name")
rs.movenext()
wend
这样写:
strSQL="SELECT Books.Title,Authors.Name FROM Books JOIN Authors ON Authors.AuthorID=Books.AuthorID"
set rs=conn.execute(strSQL)
while not rs.eof
Response.write rs("Title")&">>"&rs("Name")
rs.movenext()
wend