/插入数据/ insert into zsjhzs (SF_BH,nd,kl,pclb,zsdm,gxmc,gxbh,zslx,jhs)

    select SF_BH,nd,kl,pclb,zsdm,gxmc,gxbh,zslx,sum(ZSRS) jhs from zsjh where SF_BH=55 GROUP BY SF_BH,nd,kl,pclb,zsdm,gxmc,gxbh,zslx;

    /去年千年计划数/

    update zsjhzs set jhs_sn=(select SUM(ZSRS) from zsjh where zsjh.SF_BH=zsjhzs.SF_BH and zsjh.kl=zsjhzs.kl and zsjh.PCLB=zsjhzs.PCLB

    and zsjh.zslx=zsjhzs.zslx and zsjh.GXBH=zsjhzs.gxbh and zsjh.nd=zsjhzs.ND-1) where SF_BH=55;

    update zsjhzs set jhs_qn=(select SUM(ZSRS) from zsjh where zsjh.SF_BH=zsjhzs.SF_BH and zsjh.kl=zsjhzs.kl and zsjh.PCLB=zsjhzs.PCLB

    and zsjh.zslx=zsjhzs.zslx and zsjh.GXBH=zsjhzs.gxbh and zsjh.nd=zsjhzs.ND-2) where SF_BH=55;

    /去年千年投档线/

    update zsjhzs set tdx=(select zdfwc from tdx where tdx.SF_BH=zsjhzs.SF_BH and tdx.kl=zsjhzs.kl and tdx.PCLB=zsjhzs.PCLB

    and tdx.zslx=zsjhzs.zslx and tdx.GXBH=zsjhzs.gxbh and tdx.nd=zsjhzs.ND-1) where SF_BH=55;

    update zsjhzs set sntdx=(select zdfwc from tdx where tdx.SF_BH=zsjhzs.SF_BH and tdx.kl=zsjhzs.kl and tdx.PCLB=zsjhzs.PCLB

    and tdx.zslx=zsjhzs.zslx and tdx.GXBH=zsjhzs.gxbh and tdx.nd=zsjhzs.ND-2) where SF_BH=55;