<%
sql="select 定单号的字段名 from table
sql1="select 商品货号的字段名 from table where 定单号的字段名="
rs=cn.Execute (sql)
do while not rs.EOF
%>
<tr>
<td>定单号:<%=rs("定单号的字段名")%></td>
<%
rs1=cn.Execute (sql1)
do while not rs.EOF%>
<td>商品货号:<%=rs1("商品货号的字段名")%></td>
<%
rs1.MoveNext
loop
%>
</tr>
<%
rs.MoveNext
loop
%>