如何精简此SQL文?高手请进!

[wangzhenzhu1975]

select b.officeid,b.budgetno,b.budgetitem,
(select sum(yearbudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as yearbudget,
(select sum(onebudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as onebudget,
(select sum(twobudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as twobudget,
(select sum(threebudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as threebudget,
(select sum(fourbudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as fourbudget,
(select sum(fivebudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as fivebudget,
(select sum(sixbudget) from budgetinfor where budgetno like rtrim(b.budgetno)+'%' and officeid='8888')
as sixbudget
from budgetinfor b
join financesubject f
on f.subjectid=b.budgetno
where officeid='8888'
and f.lastsubject='0'

[Ouyangyifeiczy]

楼主这个问题表述不太清楚。JOIN financesubject 这个表数据好象都没用着，可以放在条件里啊。
另：那么多 sum(...) 如果如你所说，完全可以单独生成一张表，在处理啊
select sum(field1),sum(field2),.... from ... where budgetno like rtrim(b.budgetno)+'%' and officeid='8888'...

[wangzhenzhu1975]

是在同一张表里取,你没见吗?

[meteorlg]

如果速度很慢的话，试一下用临时表
先将数据插入临时表，需要sum的字段用0代替，然后对每个需要sum的字段执行update

[wangzhenzhu1975]

谁有办法?