下面的sql,能否不用临时表?
select XZJD_MC, B.jfxzc_mc,B.JFXZC_MJ,B.QX_DM,B.zq_dm,B.jfxzc_dm,
(select sum(tb_mj) from ST_DLTB where DL_DM='111' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as e111,
(select sum(tb_mj) from ST_DLTB where DL_DM='325' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as cw325
into #ccc
from st_xzorjd as A
inner join st_jforxzc B on SUBSTRING(A.XZJD_DM,7,3)=B.zq_dmselect xzjd_mc,sum(jfxzc_mj)as jfxzc_mj,sum(e111) as e111,sum(cw325) as cw325
from #ccc
group by xzjd_mcdrop table #ccc
非常感谢
select XZJD_MC, B.jfxzc_mc,B.JFXZC_MJ,B.QX_DM,B.zq_dm,B.jfxzc_dm,
(select sum(tb_mj) from ST_DLTB where DL_DM='111' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as e111,
(select sum(tb_mj) from ST_DLTB where DL_DM='325' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as cw325
into #ccc
from st_xzorjd as A
inner join st_jforxzc B on SUBSTRING(A.XZJD_DM,7,3)=B.zq_dmselect xzjd_mc,sum(jfxzc_mj)as jfxzc_mj,sum(e111) as e111,sum(cw325) as cw325
from #ccc
group by xzjd_mcdrop table #ccc
非常感谢
from
(
select XZJD_MC, B.jfxzc_mc,B.JFXZC_MJ,B.QX_DM,B.zq_dm,B.jfxzc_dm,
(select sum(tb_mj) from ST_DLTB where DL_DM='111' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as e111,
(select sum(tb_mj) from ST_DLTB where DL_DM='325' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as cw325
from st_xzorjd as A
inner join st_jforxzc B on SUBSTRING(A.XZJD_DM,7,3)=B.zq_dm
) B
group by xzjd_mc
(
select XZJD_MC, B.jfxzc_mc,B.JFXZC_MJ,B.QX_DM,B.zq_dm,B.jfxzc_dm,
(select sum(tb_mj) from ST_DLTB where DL_DM='111' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as e111,
(select sum(tb_mj) from ST_DLTB where DL_DM='325' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as cw325
from st_xzorjd as A
inner join st_jforxzc B on SUBSTRING(A.XZJD_DM,7,3)=B.zq_dm
) t
group by xzjd_mc
(select sum(tb_mj) from ST_DLTB where DL_DM='111' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as e111,
(select sum(tb_mj) from ST_DLTB where DL_DM='325' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as cw325
--into #ccc
from st_xzorjd as A
inner join st_jforxzc B on SUBSTRING(A.XZJD_DM,7,3)=B.zq_dm
group by xzjd_mc