错误的写法：

insert into wycy_cpjgwh(cpcode,yqcode,cpmc) select cpcode,yqcode,cpmc from wycy_cpdj_public where cpcode=:cpcode and yqcode=:yqcode and cpyw=:cpyw and shr is not null using sqlca;

 如上写法会有问题，后面的select 要加括号（）

 正确的写法：

insert into wycy_cpjgwh(cpcode,yqcode,cpmc) (select cpcode,yqcode,cpmc from wycy_cpdj_public where cpcode=:cpcode and yqcode=:yqcode and cpyw=:cpyw and shr is not null) using sqlca;