这种查询该怎么做?

[limingdedujuan]

用asp+vbscript做的

<%
set rs=server.createobject("adodb.recordset")
sql="select major.major_no,count(*) as count from class,stu_info,major where class.major_no=major.major_no and class.class_no=stu_info.class_no and major.d_no="&xy&" group by major.major_no"
rs.open sql,conn,3,3
%>

我想在结果集rs中加入对应的major_name,
可是在sql查询中,
如果用到集合函数,那么select选择的字段,只能是group by和count使用过的,我该怎么样查询?

我想得到的结果是:
rs有三个字段:major_no,major_name,count

[gahade]

<%
set rs=server.createobject("adodb.recordset")
sql="select major.major_no,major.major_name,count(*) as count from class,stu_info,major where class.major_no=major.major_no and class.class_no=stu_info.class_no and major.d_no="&xy&" group by major.major_no,major.major_name"
rs.open sql,conn,3,3
%>

[limingdedujuan]

谢谢,这样就可以了!
你知道哪里有网页的模版下载吗?

[gahade]

呵呵,不太清楚.
Baidu一下吧. :)