如何写按B表分类求和排序的SQL语句?

[飞天凤凰601]

我这有2个表
A表内容如下:
classid class
1 欧
2 王
3 罗
4 郑

B表内容如下:
classid hit
1 2
2 4
3 8
3 10
1 8
2 11
4 18
4 28

我想做的是:按B表的classid分类,对hit求和排序,再把这个排序传给A表,让A表的排序顺序是B表的结果
也就是
select * from A order by classid desc
而这个按classid要是B表的分类求和顺序

这句SQL该如何写,先谢过

[paoluo]

Select A.*
from A Left Join B On A.classid=B.classid
Group By A.classid,class
Order By SUM(hit) Desc

[netmin]

select * from a
order by (select sum(hit) from b where a.classid=classid group by classid )

这是sum求和的按升序排列

如果降序的话

select * from a
order by (select top 1 sum(hit) from b where a.classid=classid group by classid order by 1 desc )

[飞天凤凰601]

谢谢,OK了