show hand 技术:asp中怎么查询rycontent表中rycontent_id等于title表中id的所有信息!查询语句怎么么写?????急!!!!
先把title表中的所有ID值存到数组title中,然后:sql2="select * from rycontent where rycontent_id="&title(i)
明白了吗?
<%
set conn=server.CreateObject("adodb.connection")
connsrt="dbq="+server.MapPath("..\db\#db.mdb")+";driver={microsoft access driver (*.mdb)};"
conn.open connsrt
%>
<%
set rs= server.CreateObject ("Adodb.recordset")
sql="select * from title"
rs.open sql,conn,1,1
%>
<%
dim title()
for i=0 to rs.recordcount-1
redim title(i+1)
next
for i=0 to rs.recordcount-1
title(i)=rs("id")
rs.movenext
next
for i=0 to ubound(title)
set rs2= server.CreateObject ("Adodb.recordset")
sql2="select * from rycontent where rycontent_id="&title(i)
rs2.open sql2,conn,1,1
do while not rs2.eof
response.write rs2("id")&"<br>"
rs2.movenext
loop
next
conn.close
%>
SELECT a.* FROM rycontent a,title b WHERE a.rycontent_id = b.id
多表查询最好这样写。
SELECT rycontent.* FROM rycontent, title WHERE rycontent.rycontent_id = title.id