我把昨天的代码改写成如下：还是那个错误呀！怎么办？？？？？？
<table border="1" cellpadding="0" cellspacing="0" width="90%" bordercolordark="#FFCC99" bordercolorlight="#FFCC99" style="border-collapse:collapse">
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select second_class_name from big_class wherebig_class_name in (select big_class_name from big_class) order by id desc",conn,1,1
 do while not rs.eof %>
    <tr height="30"><td bgcolor="#eaeaea" valign="bottom" align="center"><%=trim(rs("big_class_name"))%> </td></tr>       
    <tr><td><%=trim(rs("second_class_name"))%></td></tr>
<% rs.movenext
    loop
rs.close
set rs=nothing%>                  
</table>

“ wherebig_class_name ”之间有空格的。

<table border="1" cellpadding="0" cellspacing="0" width="90%" bordercolordark="#FFCC99" bordercolorlight="#FFCC99" style="border-collapse:collapse">
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from second_class where big_class_name in (select big_class_name from big_class) order by id desc",conn,1,1
 do while not rs.eof %>
    <tr height="30"><td bgcolor="#eaeaea" valign="bottom" align="center"><%=trim(rs("big_class_name"))%> </td></tr>       
    <tr><td><%=trim(rs("second_class_name"))%></td></tr>
<% rs.movenext
    loop
rs.close
set rs=nothing%>                  
</table>