Question

asp中如何从多个表中查询数据 (字段都一样)然后根据一个字段排序

rs.Source= "SELECT * FROM crsh,itsm,qgzx,xxdd,xywh,yl order by dianji ASC"
我的是这样,那有错?该怎么写
不是各个表里独自的排序我要的是集合这几个表的内容然后在排序
原来那个不是
效果和原来你给我的一样
我想做个函数把各个表里的文章根据点机的多少来排序

Answer 1

select crsh.a
from
crsh,
itsm,
qgzx,
xxdd,
xywh,
yl
and
crsh.a=itsm.b
itsm.b=qgzx.c
qgzx.c=xxdd.d
xxdd.d=xywh.e
xywh.e=yl.f
order by
dianji ASC

a-f 都是表示相同的字段，只是在不同表中的。
这个是关联查询，你可以查下着方面的资料．
还有外联，内联之说，我忘记的差不多了，也不晓得对不对．

Answer 2

SELECT * FROM (
SELECT * FROM crsh
UNION
SELECT * FROM itsm
UNION
SELECT * FROM qgzx
UNION
SELECT * FROM xxdd
UNION
SELECT * FROM xywh
UNION
SELECT * FROM yl)
ORDER BY dianji ASC

是对的就是有一个问题需要根据需求改动
union 是会过滤掉重复记录的
union all 不会过滤重复记录

Answer 3

function hot(N,len1)
dim i, cha
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = conn

rs.Source= "SELECT * FROM ( SELECT * FROM crsh UNION SELECT * FROM itsm UNION SELECT * FROM qgzx UNION SELECT * FROM xxdd

UNION SELECT * FROM xywh UNION SELECT * FROM yl) ORDER BY dianji ASC "

rs.Open ,,1,1
i=0
response.write("<td width=80% valign=top>")
rs.Movefirst
do while not rs.eof and i<N
cha=rs("biaoti")
if len1<len(rs("biaoti")) then
cha=left(rs("biaoti"),len1)

response.write("<a title='"&rs("biaoti")&"' class='css1' target='_blank' href=list.asp?id="&rs("id")&"&select1="&rs

("class1")&" >"&cha&"</a>......<br >")
else

response.write("<a title='"&rs("biaoti")&"' class='css1' target='_blank' href=list.asp?id="&rs("id")&"&select1="&rs

("class1")&" >"&cha&"</a><br >")
end if
rs.Movenext
i=i+1
loop

response.write("</td>")
i=0
response.write("<td width=20% valign=top nowrap=nowrap>")
rs.Movefirst
do while not rs.eof and i<N

response.write("<a class='css1' target='_blank' href=list.asp?id="&rs("id")&"&select1="&rs("class1")&" >"&rs("time")

&"</a><br >")

rs.Movenext
i=i+1
loop
response.write("</td>")
rs.close
set rs=nothing
end function
这个是我的程序
而且第2个循环没用了 恐怕是rs.movefirst的问题
走过路过的各位大哥大婶帮帮小弟吧~~~~TT

Answer 4

那就试试这个

SELECT * FROM (
SELECT * FROM crsh
UNION
SELECT * FROM itsm
UNION
SELECT * FROM qgzx
UNION
SELECT * FROM xxdd
UNION
SELECT * FROM xywh
UNION
SELECT * FROM yl)
ORDER BY dianji ASC

Answer 5

没做过么多么表相连的.呵呵
最好先做几个表的相连的视图.再把视图连.