三个表:
P_BigClass(字段:BigClassID,BigClassName,descid),
P_SmallClass(字段:SmallClassID,BigClassName,SmallClassName,descid),
P_Sales(字段:SalesID,SmallClassName,SalesName,descid)
<%
do while not rsP_BigClass.eof
%>
">
<%
set rsP_SmallClass=server.CreateObject("adodb.recordset")
rsP_SmallClass.open "Select * From P_SmallClass Where BigClassName='" & rsP_BigClass("BigClassName") & "' order by descid",conn,1,3
if not(rsP_SmallClass.bof and rsP_SmallClass.eof) then
do while not rsP_SmallClass.eof
%>
">
<%
set rsP_Sales=server.CreateObject("adodb.recordset")
rsP_Sales.open "Select * From P_Sales Where smallClassName='" & rsP_SmallClass("smallClassName") & "' order by descid",conn,1,3
if not(rsP_Sales.bof and rsP_Sales.eof) then
do while not rsP_Sales.eof
%>
">
<%
rsP_Sales.movenext
loop%>
<%else%>
<%
end if
rsP_Sales.close
set rsP_Sales=nothing
%>
<%
rsP_SmallClass.movenext
loop
end if
rsP_SmallClass.close
set rsP_SmallClass=nothing
%>
<%
rsP_BigClass.movenext
loop
%>