请教这条Sql语句应该怎么写？高手请进！

[Endlessrain]

有2张表
表a 是学生的基本信息 字段有id 等
表b 是学生的成绩表 字段有id ,course ,score 其中id 作为外键关联
我想select * from a 并且再加一个sumScore字段，该字段是表b中该学生所有成绩的总和，请教各位这条语句应该怎么写啊？

[wgy2008]

select a.*,b.sum(score)
from a,b
where a.id = b.id
group by a.id

[97866]

Select a.*,SumScore=tem.aa from a,(Select id,aa=Sum(score) from b Group by id)tem
where a.id=tem.id

[happydreamer]

select a.*,sum(score) as sumScore
from 表a a join 表b b on a.id=b.id
group by a.id,a..... --列表

[happydreamer]

select a.*,sum(score) as sumScore
from 表a a join 表b b on a.id=b.id
group by a.id,a..... --列表

[friendliu]

select a.id,a.xm,sum(score)
from a ,b
where a.id=b.id
group by a.id,a.xm

[dafu71]

Select a.*, SumScore from a,(Select id,Sum(score) as SumScore from b Group by id)tem where a.id=tem.id

[Endlessrain]

谢谢，马上给分!

[stephenlai]

Select a.*,temp.aa from a inner join (Select id,Sum(score) as aa from b Group by id) as tem on a.id=tem.id