一个插入问题,很急,老大们帮我!
我想将查询里的sum(aaa.c1) BAL的值插入到MIDDLE表里的bal字段里去,为什么不能播入啊.
insert into DB2ADMIN.MIDDLE (NAME,ROW,LIST,value)
select 123,01,02,bal from (
select sum(aaa.c1) BAL from
( Select sum(A.MSTD_AC_NO) c1 from B027.TDFMSTD A,B027.TDFMST B
where A.MSTD_CCY='SGD' AND B.MST_AC_STATUS='N'
AND (SUBSTR(CHAR(A.MSTD_AC_NO),12,1) in ('1','2','3','4'))
AND A.MSTD_BAL<20000
union
Select SUM(MST_AC_NO) c1 from B027.DDFMST
where MST_CCY='SGD' AND MST_AC_STS='N'
AND (SUBSTR(CHAR(MST_AC_NO),12,1)in ('1','2','3','4'))
AND MST_CURR_BAL<20000
) as aaa) a