将查询结果插入到另一条张表中

 

 

<insert id="information.addInformationReceiver" parameterClass="information">
  insert into crm.crm_t_information_receiver receiver
        (
          receiver.information_id,
          receiver.customer_no,
          receiver.create_by,
          receiver.create_dt
        ) select
              #id#,custNo,#createBy#,#createDt#

               --得到custNo的值
              from (
                   select INF.CUSTOMER_NO as custNo
          from kf.kf_t_cust_inf INF where INF.customer_no IN ($customerNo$)
                   )
         
 </insert>