select koufenbiao.id, stuinfo.name ,(select sum(numeric) from koufenbiao group by id)
from stuinfo
where stuinfo.id=koufenbiao.id
order by koufenbiao,id
from stuinfo
where stuinfo.id=koufenbiao.id
order by koufenbiao,id
调试欢乐多
stuinfo.name
from stuinfo,(select sum(numeric) from koufenbiao group by id)
koufenbiao where stuinfo.id=koufenbiao.id 看看红色部分. 后面的select语句不包括ID,前面怎么能去select??
|
|
koufenbiao id,numeric,date
想查询出stuinfo中的name,koufenbiao中的各个id的总numeric.
能说得明白点吗,我的sql学得不怎么好,而且是第一次这样写!
select b.id, a.name , b.sum_numeric
from stuinfo a,(select id, sum_numeric=sum(numeric) from koufenbiao group by id) b
where a.id=b.id
但还是谢谢你的帮助!