满意答案
intothewest
2013.06.09
采纳率：52% 等级：10
已帮助：2168人
select p.requi_form,
sum(decode(p.requi_form, '0', r.bid_amount, 0)) a,
sum(decode(p.requi_form, '1', r.bid_amount, 0)) b,
sum(decode(p.requi_form, '2', r.bid_amount, 0)) c,
sum(decode(p.requi_form, '3', r.bid_amount, 0)) d,
sum(decode(p.requi_form, '4', r.bid_amount, 0)) e,
sum(p.bid_amount) 采购金额,
sum(r.bid_amount) 招标采购金额,
sum(r.bid_amount) / sum(p.bid_amount) 招标采购率
from cg_purchase_project p,
cg_purchase_report r
where r.purc_pro_id = p.purc_pro_id
and p.purc_pro_state != 11
group by p.requi_form
order by p.bid_team;
00分享举报