insert into erp_ckscd
(
ckdbh,
cklx,
kfxxid,
create_date,
iftrans,
yhbh,
bcdjh,
yhbh2,
cph,
groupid,
md_kfxxid
)
select ccd.zcdbh ckdbh, ccd.cklx, ccd.fh_kfid kfxxid, sysdate createdate, 1 iftrans,
ccd.wc_userid yhbh, '' bcdjh, ccd.userid yhbh2,
(select cl.clxxmc from xs_clxx cl where cl.clxxid = ccd.clxxid) cph, ccd.groupid ,md_kfid
from xs_ccd ccd where ccd.zcdbh = #{ckdbh}