<%
sql = "SELECT * FROM Accounts.dbo.view_2 where IsAndroid = 0"
set rs = conn.execute(sql)
if not rs.eof then
do while not rs.eof
%>
<tr>
<td><%=rs("USERID")%></td>
<td><%=rs("ACCOUNTS")%></td>
</tr>
<%
rs.movenext
loop
else
%>
上面查询符合条件显示
userid ACCOUNTS NEWS
1 test ?
然后我想在 NEWS获取前面USERID 在执行 SELECT SUM(Score) FROM View_3 where userid = userid 的合计结果 应该要怎么写?