ASP½µÐòÎÊÌâ

    <%
  Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
  %>

ÔõÑùÈÃËû¶ÁÈ¡µ½Êý¾Ý¿âµÄ½µÐòIDÄØ
Ò²¾ÍÊÇÈÃËùÓÐÎÄÕ±êÌâ×îеÄʼÖÕÔÚ×îÇ°Ãæ

---

ÊÔÊÔ¿´
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"

---

¶Á³ö½á¹û°´ d_classid ×ֶνµÐòÅÅÁÐ...

<%
  Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by d_classid desc"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
%>

---

Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"

---

dao!

---

<%
  Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by d_classid desc "
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
  %>

---

ÉÏÃæµÄ·½·¨¶¼¿ÉÒÔ£¬ÊÔÊÔ°É

---

Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"