一条sql语句不会写,求助

[zhengoodman]

select sum(C.compl_qty*D.bkc_unit_price) bkc_amt
from (select nvl(sum(compl_qty),0) compl_qty,item_no
from completion_trans
where item_no in ('A1065336A','A1065340A','A7078598B')
and joc_cd='DC001223'
and sc_cd='AC001'
and ws_compl_dte=20040604) C,
(select nvl(sum(decode(sign(i.std_cost_eff_dte -20040604),-1,i.std_cost2,i.std_cost1)
* decode(m.usage_type,0,m.usage_dec,m.usage_numerator/m.usage_denominator)),0) bkc_unit_price,m.bkc_cd bkc_cd '问题出在这
from mfg_bom_master m, item_master i
where m.bkc_cd in ('A1065336A','A1065340A','A7078598B')
and i.item_no=m.child_item_cd) D
where C.item_no=D.bkc_cd

报错ora-00937,不知错在哪儿?

[zhengoodman]

有没有人?....任何人....自己顶

[zhengoodman]

天哪,不会没人看到这个贴子吧?

拜托,帮帮忙.

其中m.bkc_cd bkc_cd处出错.

[zhengoodman]

不能沉,奋力一顶.

[feng1959]

select sum(C.compl_qty*D.bkc_unit_price) bkc_amt
from (select nvl(sum(compl_qty),0) compl_qty,item_no
from completion_trans
where item_no in ('A1065336A','A1065340A','A7078598B')
and joc_cd='DC001223'
and sc_cd='AC001'
and ws_compl_dte=20040604
group by item_no
) C,
(select nvl(sum(decode(sign(i.std_cost_eff_dte -20040604),-1,i.std_cost2,i.std_cost1)
* decode(m.usage_type,0,m.usage_dec,m.usage_numerator/m.usage_denominator)),0) bkc_unit_price,m.bkc_cd bkc_cd
from mfg_bom_master m, item_master i
where m.bkc_cd in ('A1065336A','A1065340A','A7078598B')
and i.item_no=m.child_item_cd
group by bkc_cd
) D
where C.item_no=D.bkc_cd