sql="select * from Dv_bbs1 where isupload=1 order by AnnounceID desc"
set rs=conn.execute(sql)sql2="select * from Dv_Topic where Child>10 and TopicID="&rs("RootID")&""
set rs1=conn.execute(sql2)sql3="select * from Dv_upfile where F_BoardID="&rs1("BoardID")&" and F_Readme='"&rs1("title")&"' and F_Username='"&rs1("PostUserName")&"'"
set rs2=conn.execute(sql3)就是三个表的查询语句,可以写成一句吗?
//set rs=conn.execute(sql)sql2="select * from Dv_Topic where Child>10 and TopicID="&rs("RootID")&""
//set rs1=conn.execute(sql2)sql3="select * from Dv_upfile where F_BoardID="&rs1("BoardID")&" and F_Readme='"&rs1("title")&"' and F_Username='"&rs1("PostUserName")&"'"
//set rs2=conn.execute(sql3)
set rs2=conn.execute(sql+"union all"+sql2+"union all"+sql3)