<%
conc="数据库连接字符串"
sql="
select a.* from
(
(select * from table1)
union all
(select * from table2)
union all
(select * from table3)
union all
......
) a
where a.名称="学生名" or a.平均分>80"
set rs=server.createobject("adodb.recordset")
rs.open sql,conc,1,1
%>
select a.* from
(
(select * from table1)
union all
(select * from table2)
union all
(select * from table3)
union all
......
) a
where a.名称="学生名" or a.平均分>80