select a.CREATED , a.DOMAINID , a.ITEM_AUDITSTATUS , a.ITEM_REGION, a.ITEM_OFFICEPOLICEADDRESS, a.ITEM_OFFICEPOLICEADDRESSID, a.ITEM_OFFICEPOLICEIDINDEX, a.ITEM_COMPANYNAME, a.ITEM_ADDRESS, a.ITEM_SECURITYTRAINPERMITNO, a.ITEM_LEGALNAME, a.ITEM_LEGALSEX, a.ITEM_OFFICESTARTTIME, a.ITEM_OFFICEENDTIME, a.ITEM_LEGALTYPE, a.ITEM_LEGALCARDNUMBER, a.ITEM_APPOINTMENTLEGALNAME, a.ITEM_APPOINTMENTLEGALSEX, a.ITEM_APPOINTMENTLEGALBIRTH, a.ITEM_APPOINTMENTLEGALNATIONALITY, a.ITEM_APPOINTMENTLEGALCULTURE, a.ITEM_APPOINTMENTLEGALPHONE, a.ITEM_APPOINTMENTLEGALTYPE, a.ITEM_APPOINTMENTLEGALCARDNUMBER, a.ITEM_ORIGINALISSUINGDATE, a.ITEM_FILE, a.ITEM_REJECTREASON, a.ITEM_DOMAIN_ID, a.ITEM_PERMIT, a.ID, b.ITEM_TOPID as TOPID,b.ITEM_STARTDATE as STARTDATE,b.ITEM_ENDDATE as ENDDATE,b.ITEM_WORKCOMPANYNAME as WORKCOMPANYNAME,b.ITEM_POST as POST,b.id as RID,b.created as RCREATED from securityflow.tlk_legalchangek a left join securityflow.tlk_Resume b on a.id=b.item_topId a.ID in #{id} where ID = #{id} insert into securityflow.tlk_legalchangek PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHORDEPTID, AUTHOR_DEPT_INDEX, AUTHOR_USER_INDEX, CREATED, FORMID, SUBFORMIDS, INITIATOR, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_REGION, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_ADDRESS, ITEM_SECURITYTRAINPERMITNO, ITEM_LEGALNAME, ITEM_LEGALSEX, ITEM_OFFICESTARTTIME, ITEM_OFFICEENDTIME, ITEM_LEGALTYPE, ITEM_LEGALCARDNUMBER, ITEM_APPOINTMENTLEGALNAME, ITEM_APPOINTMENTLEGALSEX, ITEM_APPOINTMENTLEGALBIRTH, ITEM_APPOINTMENTLEGALNATIONALITY, ITEM_APPOINTMENTLEGALCULTURE, ITEM_APPOINTMENTLEGALPHONE, ITEM_APPOINTMENTLEGALTYPE, ITEM_APPOINTMENTLEGALCARDNUMBER, ITEM_ORIGINALISSUINGDATE, ITEM_FILE, ITEM_REJECTREASON, ITEM_DOMAIN_ID, ITEM_PERMIT, ID, #{parent}, #{lastmodified}, #{formname}, #{state}, #{audituser}, #{auditdate}, #{author}, #{authordeptid}, #{authorDeptIndex}, #{authorUserIndex}, #{created}, #{formid}, #{subformids}, #{initiator}, #{istmp}, #{versions}, #{applicationid}, #{stateint}, #{statelabel}, #{auditornames}, #{lastflowoperation}, #{lastmodifier}, #{domainid}, #{auditorlist}, #{coauditorlist}, #{statelabelinfo}, #{prevauditnode}, #{prevaudituser}, #{optionitem}, #{sign}, #{kinggridsignature}, '3', #{tlkformname}, #{region}, #{officepoliceaddress}, #{officepoliceaddressid}, #{officepoliceidindex}, #{companyname}, #{address}, #{securitytrainpermitno}, #{legalname}, #{legalsex}, #{officestarttime}, #{officeendtime}, #{legaltype}, #{legalcardnumber}, #{appointmentlegalname}, #{appointmentlegalsex}, #{appointmentlegalbirth}, #{appointmentlegalnationality}, #{appointmentlegalculture}, #{appointmentlegalphone}, #{appointmentlegaltype}, #{appointmentlegalcardnumber}, #{originalissuingdate}, #{file}, #{rejectreason}, #{domainId}, #{permit}, #{id}, insert into securityflow.tlk_Resume CREATED, lastmodified, FORMID, APPLICATIONID, DOMAINID, ITEM_TOPID, ITEM_STARTDATE, ITEM_ENDDATE, ITEM_WORKCOMPANYNAME, ITEM_POST, ID, #{created}, #{lastmodified}, #{formid}, #{applicationid}, #{domainid}, #{TOPID}, #{STARTDATE}, #{ENDDATE}, #{WORKCOMPANYNAME}, #{POST}, #{id}, update securityflow.tlk_legalchangek PARENT = #{parent}, LASTMODIFIED = #{lastmodified}, FORMNAME = #{formname}, STATE = #{state}, AUDITUSER = #{audituser}, AUDITDATE = #{auditdate}, AUTHOR = #{author}, AUTHORDEPTID = #{authordeptid}, AUTHOR_DEPT_INDEX = #{authorDeptIndex}, AUTHOR_USER_INDEX = #{authorUserIndex}, CREATED = #{created}, FORMID = #{formid}, SUBFORMIDS = #{subformids}, INITIATOR = #{initiator}, ISTMP = #{istmp}, VERSIONS = #{versions}, APPLICATIONID = #{applicationid}, STATEINT = #{stateint}, STATELABEL = #{statelabel}, AUDITORNAMES = #{auditornames}, LASTFLOWOPERATION = #{lastflowoperation}, LASTMODIFIER = #{lastmodifier}, DOMAINID = #{domainid}, AUDITORLIST = #{auditorlist}, COAUDITORLIST = #{coauditorlist}, STATELABELINFO = #{statelabelinfo}, PREVAUDITNODE = #{prevauditnode}, PREVAUDITUSER = #{prevaudituser}, OPTIONITEM = #{optionitem}, SIGN = #{sign}, KINGGRIDSIGNATURE = #{kinggridsignature}, ITEM_AUDITSTATUS = #{auditstatus}, ITEM_TLKFORMNAME = #{tlkformname}, ITEM_REGION = #{region}, ITEM_OFFICEPOLICEADDRESS = #{officepoliceaddress}, ITEM_OFFICEPOLICEADDRESSID = #{officepoliceaddressid}, ITEM_OFFICEPOLICEIDINDEX = #{officepoliceidindex}, ITEM_COMPANYNAME = #{companyname}, ITEM_ADDRESS = #{address}, ITEM_SECURITYTRAINPERMITNO = #{securitytrainpermitno}, ITEM_LEGALNAME = #{legalname}, ITEM_LEGALSEX = #{legalsex}, ITEM_OFFICESTARTTIME = #{officestarttime}, ITEM_OFFICEENDTIME = #{officeendtime}, ITEM_LEGALTYPE = #{legaltype}, ITEM_LEGALCARDNUMBER = #{legalcardnumber}, ITEM_APPOINTMENTLEGALNAME = #{appointmentlegalname}, ITEM_APPOINTMENTLEGALSEX = #{appointmentlegalsex}, ITEM_APPOINTMENTLEGALBIRTH = #{appointmentlegalbirth}, ITEM_APPOINTMENTLEGALNATIONALITY = #{appointmentlegalnationality}, ITEM_APPOINTMENTLEGALCULTURE = #{appointmentlegalculture}, ITEM_APPOINTMENTLEGALPHONE = #{appointmentlegalphone}, ITEM_APPOINTMENTLEGALTYPE = #{appointmentlegaltype}, ITEM_APPOINTMENTLEGALCARDNUMBER = #{appointmentlegalcardnumber}, ITEM_ORIGINALISSUINGDATE = #{originalissuingdate}, ITEM_FILE = #{file}, ITEM_REJECTREASON = #{rejectreason}, ITEM_DOMAIN_ID = #{domainId}, ITEM_PERMIT = #{permit}, where ID = #{id} delete from securityflow.tlk_legalchangek where ID = #{id} delete from securityflow.tlk_legalchangek where ID in #{id}