<% rs=stmt.executeQuery("select * from sy_article,sub_art where sub_art.artid=sy_article.artid and sub_art.colid in (200,231) and not sy_article.picmark is null order by sy_article desc"); while(rs.next()) { %> <%} rs.close(); %>