asp 数据库查询 我要把字段sjid不同值的 grzh全部列出来？请问怎么做？谢谢

asp 数据库查询 我要把字段sjid不同值的 grzh全部列出来？请问怎么做？谢谢

<%

set rs=conn.Execute("select distinct grzh,sjid from xnsf where sjid in (select grzh form xnsf group by grzh having count(distinct(sjid))>1)")

%>

<%
do while not rs.eof

%>


<%
rs.movenext
loop
%>

qq号: <%response.Write rs("grzh")%>

追问大侠，还是提示有语法错误
set rs=conn.Execute("select distinct grzh,sjid from xnsf where sjid in (select grzh form xnsf group by grzh having count(distinct(sjid))>1)")

这句是哪里不对呢？？