求一sql复杂语句
<!-- -->
<%
set rs1=server.createobject( "adodb.recordset ")
sql= "SELECT * FROM sort where fatherID= "&request( "id ")& " "
rs1.open sql,conn,1,3
do while not rs1.eof
%>
<%set rs2=server.createobject( "adodb.recordset ")
sql= "SELECT * FROM sjzq where productSort= "&rs1( "id ")& " and
recommend=1 and userid in (select id from register where
leixing= 'aa ') order by id desc "
rs2.open sql,conn,1,3
do while not rs2.eof
%>
<tr>
<td> 名称： <%=rs2( "title ")%> </td>
</tr>
<%rs2.movenext
loop
rs2.close
set rs2=nothing
%>
<%rs1.movenext
loop
rs1.close
set rs1=nothing
%>
<!-- -->
<%
set rs1=server.createobject( "adodb.recordset ")
sql= "SELECT * FROM sort where fatherID= "&request( "id ")& " "
rs1.open sql,conn,1,3
do while not rs1.eof
%>
<%set rs2=server.createobject( "adodb.recordset ")
sql= "SELECT * FROM sjzq where productSort= "&rs1( "id ")& " and
recommend=1 and userid in (select id from register where
leixing= 'bb ') order by id desc "
rs2.open sql,conn,1,3
do while not rs2.eof
%>
<tr>
<td> 名称： <%=rs2( "title ")%> </td>
</tr>
<%rs2.movenext
loop
rs2.close
set rs2=nothing
%>
<%rs1.movenext
loop
rs1.close
set rs1=nothing

%>
<!-- -->
以上代码可以正常运行，我想加个翻页，但分成两段调用的我不会加，所以想把以上sql语句写成一句。请大家帮忙提供翻页代码或sql语句都可以，谢谢

[解决办法]
帮你顶一下吧