<a href="showpp1.asp?id=<%=rs("id")%>&type=<%=rs("title")%>" target="_blank"><%=rs("title")%></a></td>在show.asp页面
"select * from
(select * from newssafe where title like '%"&keyword&"%' union select * from tech where title like '%"&keyword&"%'") as Tbtemp
where Tbtemp.id=request("id") and Tbtemp.title=request("title")
"select * from
(select * from newssafe where title like '%"&keyword&"%' union select * from tech where title like '%"&keyword&"%'") as Tbtemp
where Tbtemp.id=request("id") and Tbtemp.title=request("title")
id = CInt(request.querystring("id"))'设置SQL语句
sql = "select * from NewsSafe where id=" & id
sql = sql & " Union"
sql = sql & " select * from tech where id=" & id