<%
    sql="select top 12 "
    sql=sql&"download.images,download.id,download.showname,download.dateandtime,download.hits,download.classid,download.Nclassid,Nclass.Nclass,download.system,download.orders,download.fromurl,download.note"
    sql=sql&" from download,Nclass where download.stop=0 and download.Nclassid=Nclass.Nclassid "
    sql=sql&" order by download.id desc"
    rs.open sql,conn,1,1

%>


download和Nclass是两个互相关连的数据表