第1个回答 2019-05-01
SELECT
SUM(zy_detail_charge.charge_amount)
,SUM(mz_charge_detail.quantity)
FROM
zy_detail_charge
,mz_charge_detail
where
zy_detail_charge.charge_code
in
(select
fee_code
from
or_level
where
or_level
=
'xt'
and
flag
=
'410')
and
data_month
='2010-08'
and
zy_detail_charge.charge_code=mz_charge_detail.charge_item_code