insert into RB_ZLRB(date,zt_bll,zt_mbz,xz_bll,xz_mbz,hck_bll,hck_mbz,dg_bll,dg_mbz,jd_bll,jd_mbz,mk_bll,mk_mbz,bm_bll,bm_mbz,dc_bll,dc_mbz,mt_bll,mt_mbz,fj_bll,fj_mbz,a_bll,a_mbz,b_bll,b_mbz,mkl_bll,mkl_mbz,bml_bll,bml_mbz,dcl_bll,dcl_mbz,mtl_bll,mtl_mbz,fjl_bll,fjl_mbz,qcl_bll,qcl_mbz,tpv_bll,tpv_mbz,gj_bll,gj_mbz,ycl_bll,ycl_mbz,wg_bll,wg_mbz,gc_bll,gc_mbz,jz_scsl,jz_blsl,jz_bll,jz_mbz,mft_scsl,mft_blsl,mft_bll,mft_mbz,jzzj_jypc,jzzj_blpc,jzzj_bll,jzzj_mbz, jh_jypc, jh_blpc, jh_bll, jh_mbz, tpv_jypc, tpv_blpc, tpv_bll,
tpv_mbz,bf_qcl,bf_lh,bf_jc,bf_jh,zxs_wtgj,dq_wtgj,aq_wtgj,zxs_wtyf,dq_wtyf,aq_wtyf,zxs_jytl,dq_jytl,aq_jytl,zxs_glxt,dq_glxt,aq_glxt) select LH_ZT.date,SUM(LH_ZT.lh_fq)/SUM(LH_ZT.lh_cl)*1000000 as zt_bll,MBZ_LH.zt_mbz, SUM(LH_XZ.lh_fq)/SUM(LH_XZ.lh_cl)*1000000 as xz_bll,MBZ_LH.xz_mbz as xz_mbz,SUM(LH_HCK.lh_fq)/SUM(LH_HCK.lh_cl)*1000000 as hck_bll,MBZ_LH.hck_mbz as hck_mbz,SUM(LH_DG.lh_fq)/SUM(LH_DG.lh_cl)*1000000 as dg_bll,MBZ_LH.dg_mbz as dg_mbz,SUM(LH_JD.lh_fq)/SUM(LH_JD.lh_cl)*1000000 as jd_bll ,MBZ_LH.jd_mbz as jd_mbz,(sum (JH_RBB.jh_fgzl)+sum(JH_RBB.jh_bfzl))/sum(JH_RBB.jh_jhzl)*1000000 AS mk_bll ,MBZ_JH.mk_mbz as mk_mbz,(sum (d.jh_fgzl)+sum(d.jh_bfzl))/sum(d.jh_jhzl)*1000000 AS bm_bll ,MBZ_JH.bm_mbz as bm_mbz,(sum (e.jh_fgzl)+sum(e.jh_bfzl))/sum(e.jh_jhzl)*1000000 AS dc_bll, MBZ_JH.dc_mbz as dc_mbz,(sum (f.jh_fgzl)+sum(f.jh_bfzl))/sum(f.jh_jhzl)*1000000 AS mt_bll,MBZ_JH.mt_mbz as mt_mbz ,(sum (g.jh_fgzl)+sum(g.jh_bfzl))/sum(g.jh_jhzl)*1000000 AS fj_bll,MBZ_JH.fj_mbz AS fj_mbz, SUM(LJ_ZLRB.lj_blcs)/ sum(LJ_ZLRB.lj_sccs)*1000000 as a_bll,MBZ_LJ.a_mbz AS a_mbz,SUM(a1.lj_blcs)/ sum(a1.lj_sccs)*1000000 as b_bll,MBZ_LJ.b_mbz AS b_mbz ,(sum (JC_JCGC.jc_ssje)+sum(JC_FLTH.jc_je)+sum(JC_BJ.jc_bfje)+sum(JC_CLBLP.jc_bfje))/sum(JC_JCJH.jc_decz)*1000000 AS mkl_bll ,MBZ_JC.mkl_mbz as mkl_mbz, (sum (h.jc_ssje)+sum(i.jc_je)+sum(j.jc_bfje)+sum(k.jc_bfje))/sum(l.jc_decz)*1000000 AS bml_bll ,MBZ_JC.bml_mbz as bml_mbz, (sum (m.jc_ssje)+sum(n.jc_je)+sum(o.jc_bfje)+sum(p.jc_bfje))/sum(q.jc_decz)*1000000 AS dcl_bll, MBZ_JC.dcl_mbz as dcl_mbz, (sum (r.jc_ssje)+sum(x.jc_je)+sum(t.jc_bfje)+sum(u.jc_bfje))/sum(v.jc_decz)*1000000 AS mtl_bll,MBZ_JC.mtl_mbz as mtl_mbz , (sum (w.jc_ssje)+sum(s.jc_je)+sum(y.jc_bfje)+sum(z.jc_bfje))/sum(aa.jc_decz)*1000000 AS fjl_bll, MBZ_JC.fjl_mbz as fjl_mbz, SUM(qcl_wtbkt)/SUM(qcl_cl)*1000000 AS qcl_bll, MBZ_QCL.qcl_mbz AS qcl_mbz, SUM(TPV_SCGC_JH.tpv_blsl)/ sum(TPV_SCGC_JH.tpv_jhsl)*1000000 as tpv_bll,MBZ_TPV.tpv_mbz AS tpv_mbz, hgl_gj as gj_hgl, mbz_gj as gj_mbz, bll_ycl as ycl_bll, mbz_ycl as ycl_mbz, bll_wg as wg_bll, mbz_wg as wg_mbz, bll_gc as gc_bll, mbz_gc as gc_mbz,RB_JZ.scsl as jz_scsl,RB_JZ. blsl as jz_blsl,RB_JZ.bll as jz_bll,RB_JZ. mbz as jz_mbz, RB_MFT.scsl as mft_scsl , RB_MFT.blsl as mft_blsl, RB_MFT.bll as mft_bll, RB_MFT.mbz as mft_mbz,jz_jypc as jzzj_jypc,jz_blpc as jzzj_blpc,jz_jzbll as jzzj_jzbll,jz_mbz as jzzj_mbz, jh_jypc as jh_jypc,jh_blpc as jh_blpc,jh_bll as jh_bll,jh_mbz as jh_mbz,tpv_jypc as tpv_jypc,tpv_blpc as tpv_blpc,tpv_bll as tpv_bll, RB_JZZJ.tpv_mbz as tpv_mbz ,je_qcl as bf_qcl,je_lh as bf_lh,je_jc as bf_jc,je_jh as bf_jh ,zxs_wtgj as zxs_wtgj,dq_wtgj as dq_wtgj,aq_wtgj as aq_wtgj,zxs_wtyf as zxs_wtyf,dq_wtyf as dq_wtyf,aq_wtyf as aq_wtyf,zxs_jytl as zxs_jytl,dq_jytl as dq_jytl,aq_jytl as aq_jytl,zxs_glxt as zxs_glxt,dq_glxt as dq_glxt,aq_glxt as aq_glxt FROM LH_ZT join LH_XZ on LH_ZT.date=LH_XZ.date left join MBZ_LH ON MBZ_LH.id=MBZ_LH.id join LH_HCK on LH_XZ.date=LH_HCK.date left join MBZ_LH as a ON MBZ_LH.id=MBZ_LH.id JOIN LH_DG on LH_HCK.date=LH_DG.date left join MBZ_LH as b ON MBZ_LH.id=MBZ_LH.id JOIN LH_JD on LH_DG.id=LH_JD.id left join MBZ_LH as c ON MBZ_LH.id=MBZ_LH.id join JH_RBB ON JH_RBB.date=LH_ZT.date inner join MBZ_JH on MBZ_JH.id=MBZ_JH.id join JH_RBB as d on d.date=LH_ZT.date JOIN JH_RBB as e on e.date=LH_ZT.date join JH_RBB as f on f.date=LH_ZT.date join JH_RBB as g on g.date=LH_ZT.date inner join MBZ_LJ ON MBZ_LJ.id=MBZ_LJ.id,JC_JCGC AS h join JC_FLTH as i on i.date=h.date join JC_BJ as j on j.date=i.date join JC_CLBLP as k on k.date=j.date join JC_JCJH as l on l.date=k.date join JC_JCGC AS m on m.date=l.date join JC_FLTH as n on n.date=m.date join JC_BJ as o on o.date=n.date join JC_CLBLP as p on p.date=o.date join JC_JCJH as q on q.date=p.date join JC_JCGC AS r on r.date=q.date join JC_FLTH as x on x.date=r.date join JC_BJ as t on t.date=x.date join JC_CLBLP as u on u.date=x.date join JC_JCJH as v on v.date=u.date join JC_JCGC on JC_JCGC. date=u.date join JC_FLTH on JC_FLTH. date=u.date join JC_BJ on JC_BJ. date=u.date join JC_CLBLP on JC_CLBLP.date=u.date join JC_JCJH on JC_JCJH.date=u.date join JC_JCGC AS w on w.date=v.date join JC_FLTH as s on s.date=w.date join JC_BJ as y on y.date=s.date join JC_CLBLP as z on z.date=y.date join JC_JCJH as aa on aa.date=z.date join MBZ_JC on MBZ_JC.id=MBZ_JC.id JOIN QCL_HZ on QCL_HZ.date=h.date join MBZ_QCL on MBZ_QCL.id=MBZ_QCL.id join TPV_SCGC_JH on TPV_SCGC_JH.date=h.date join MBZ_TPV on MBZ_TPV.id=MBZ_TPV.id