Question

asp读取多个表数据值并显示的问题!

有三个表:tz_a,tz_b,tz_c三个表的结构完全一样都有以下字段:
id | tz_num | tz_name | pc_id
表tz_a数据如下:
1 A110 测试 070101
2 A111 测试 070102
3 A112 测试 071003
表tz_b数据如下:
1 B110 测试 070101
2 B111 测试 070102
3 B112 测试 071003
表tz_c数据如下:
1 C110 测试 070101
2 C111 测试 070102
3 C112 测试 071003
我现在要一次性查询三个表中pc_id为070101的数据并如下显示:
1 A110 测试 070101
1 B110 测试 070101
1 C110 测试 070101
<%
dim keyword,SearchType
if Request("keyword")="" then
Response.Write "<script>alert('搜索关键字不能为空');window.close();</script>"
Response.End
end if
if Request("SearchType")="" then
Response.Write "<script>alert('您还没有选择发放部门,请重试！');window.close();</script>"
Response.End
end if
SearchType = request.QueryString("SearchType")
select case request("SearchType")
case"技术部"
keyWord = cint(request.QueryString("keyWord"))
sql="select tz_a.*,tz_b.*,tz_c.*,tz_d.* from tz_a,tz_b,tz_c,tz_d where tz_a.pc_id="&Cint(Keyword)&" and tz_b.pc_id="&Cint(Keyword)&" and tz_c.pc_id="&Cint(Keyword)&" and tz_d.pc_id="&Cint(Keyword)&""
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
请问显示数据的代码怎么写?
<%=rs(tz_num)%><%=rs(tz_name)%><%=rs(pc_id)%>读不出来.

Answer 1

select * from (select * from tz_a union all select * from tz_b union all select * from tz_c)t where pc_id=070101

Answer 2

select pc_id from tz_a,tz_b,tz_c where pc_id=070101

Answer 3

sql写得太差了