- 论坛徽章:
- 1
|
insert into YYGLA01_LS
(SYPXX01, SYPPH01, SYPKW01, NYPKC01, SYPPH02, DYPPH03, NYPPH04)
select a.sypxx01,a.sypph01, a.sypkw01, 0,(select sypxx05 from yygl110 where a.sypxx01 = yygl110.sypxx01),sysdate,0
from ( select sypkw01, sypxx01, SKCRZ13 as sypph01
from yygla90 where SKCRZ13 is not null
group by sypkw01, sypxx01, SKCRZ13
) a
where not exists
(select * from YYGLA01_LS b where a.sypkw01 = b.sypkw01 and a.sypxx01 = b.sypxx01
and a.sypph01 = b.sypph01 ) group by a.sypkw01,a.sypxx01,a.sypph01;
在oracle 10G中执行时,能正常执行,但是在oracle8i执行时,提示 ora-00979错误,not a group by expression.
请朋友们看看有什么办法解决不? |
|