% qMRS = " SELECT s.mis_id,s.mis_nome,m.min_nome,m.min_id " qMRS = qMRS & " FROM tb_MinistSub s INNER JOIN " qMRS = qMRS & " tb_Ministerios m ON s.min_id = m.min_id " qMRS = qMRS & " ORDER BY m.min_nome " set minRS = conexao.execute(qMRS) nomeAtual = "" do until (minRS.eof) if (minRS("min_nome") <> nomeAtual) then if (nomeAtual <> "") then %> <% end if %>
<%= minRS("mis_nome") %> <%= cont %>