老师好!
news表中有字段articleid,title,picurl,classid,addtime.
实现的功能是:把栏目classid=3中的新闻图片从第5张开始,把栏目classid=20所有图片合在一起集中显示,下面的代码不能实现,看书说用UNION联合查询又不会写,请教各位老师如何写这段代码?
<%set rs=server.CreateObject("adodb.recordset")
sql= "select articleid,title,picurl from news where (classid=20 or classid=3) order by addtime desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<center><br><font color=red size=2>对不起，暂无图片！</font></font>"
response.End

谢谢! 我上面的代码sql= "select articleid,title,picurl from news where (classid=20 or classid=3) order by addtime desc"是楼上老师所说的意思,会把栏目3和栏20中所有图片都查出来。

我现在求助的是:如何取出栏目3中从第5张开始的图片加上栏目20中所有的图片。主要的意思是去掉classid=3的前5张图片后组成一个记录集RS。
相当于sql= "select articleid,title,picurl from news where classid=20 order by addtime desc"
sql= "select 去掉前5张 articleid,title,picurl from news where classid=3 order by articleid desc"
两个合在一起。

谢谢您的回复,下面代码运行时,没有错误提示,也没有图片显示,什么原因?
<table border=0 cellpadding=0 cellspacing=0>
<tr>
<%set rs1=server.CreateObject("adodb.recordset")
sql1="select * from news where classid=3 order by addtime desc"
rs1.open sql1,conn,1,1
rs1.movePrevious
for i =1 to 6
if rs1.eof then
exit for
response.End
end if
rs1.movenext
next
id=rs1("articleid")
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from news where classid=20 union select * from news where classid=3 and articleid>"&id
rs2.open sql2,conn,1,1
for j=1 to rs2.recordcount
if rs2.eof then
exit for
end if
%>
<td > <a href="tpxw.asp?id=<%=rs2("articleid")%>" class="list5" target=_blank><img src="<%=trim(rs2("picurl"))%>" alt="<%=rs2("title")%>" width="100" height="80" border="1" align="top" ></a >
</td>
<% rs2.movenext
next

%>
</tr>
</table>

谢谢qhscqb的回复,我把 sql2="select * from news where classid=20 union select * from news where classid=3 and articleid>"&id
换成sql2="select articleid,title,picurl from news where classid=20 union select articleid,title,picurl from news where classid=3 and articleid>"&id后,可以运行了,但是与要求反了,它显示了20所有的图片和栏目3的前5张图片,而不是去掉前5张.
请您再看下怎回事?再次感谢!!!!

老师您好!我把前部分set rs1=server.CreateObject("adodb.recordset")
sql1="select * from news where classid=3 order by addtime desc"
rs1.open sql1,conn,1,1
rs1.movePrevious
for i =1 to 6
if rs1.eof then
exit for
response.End
end if
rs1.movenext
next
单独运行RS1记录集可以实现去掉前5张的效果.数据库是SQL2000.
用sql2="select * from news where classid=20 union all select * from news where classid=3 and articleid>"&id
效果上面情况一样.