insert into SHGL_SUMFORDLSBH_TP(DLSBH,SUMTOTAL) select b.DLSBH, sum(aa.TOTAL) from SHGL_CHANGEDATA_TP aa, SHGL_DAILISHANG_TP b where aa.DLSBH=b.DLSBH;
这样写怎么说表和视图不存在!!!!!!!??????????
谢谢回复!!!!!!!!!
这样写怎么说表和视图不存在!!!!!!!??????????
谢谢回复!!!!!!!!!
调试欢乐多
insert into SHGL_SUMFORDLSBH_TP(DLSBH,SUMTOTAL) select b.DLSBH, sum(aa.TOTAL) as SUMTOTAL from SHGL_CHANGEDATA_TP aa, SHGL_DAILISHANG_TP b where aa.DLSBH=b.DLSBH;
--漏写group by
insert into SHGL_SUMFORDLSBH_TP(DLSBH,SUMTOTAL)
select b.DLSBH, sum(aa.TOTAL) SUMTOTAL from SHGL_CHANGEDATA_TP aa, SHGL_DAILISHANG_TP b where aa.DLSBH=b.DLSBH
group by b.DLSBH;