es posible poner una consulta sql dentro de un ciclo while?

[tammander]

Código:

Set rs1 = conn.execute("SELECT * FROM facturas WHERE id = " & idfactura)

do while not rs1.EOF
    response.write "<select name=""clientes"">"
    set rs2 = conn.execute("SELECT * FROM clientes ORDER BY nombre")
    do while not rs2.EOF
         response.write "<option value=""" & rs2("idcliente") & """
         if rs2("idcliente") = rs1("idcliente") then response.write " seleted"
         response.write ">" & rs2("nombre") & "</option>"
         rs2.movenext
         
    loop
    rs2.close
    set rs2 = nothing
     rs1.movenext
loop

rs1.close
set rs1 = nothing

Un saludo