28,390
社区成员
发帖
与我相关
我的任务
分享
if rs("表名") = "表1" then url = "aa.asp"
if rs("表名") = "表2" then url = "bb.asp"
response.write "<a href='" & url & "?id=" & rs("id") &"'>" & rs("name") & "</a>"
select 表名,id,name,old
from
(
select "表1" 表名,id,name,old from 表1
union
select "表2" 表名,id,name,old from 表2
)
order by old desc