复制一行记录 insert into select

insert into tb_sys_menu
  (menu_id,
   menu_nm,
   menu_desc,
   menu_pid,
   menu_level,
   link_url,
   sys_cd,
   menu_stat_cd,
   disp_seq,
   etr_id,
   etr_date,
   mdf_id,
   mdf_date,
   is_data_menu,
   open_yn,
   menu_id_old,
   menu_pid_old)
  select '302014',
      '采购未到货',
         t2.menu_desc,
         t2.menu_pid,
         t2.menu_level,
         'purch/po_not_receive.ugo',
         t2.sys_cd,
         t2.menu_stat_cd,
         t2.disp_seq,
         t2.etr_id,
         t2.etr_date,
         t2.mdf_id,
         t2.mdf_date,
         t2.is_data_menu,
         t2.open_yn,
         t2.menu_id_old,
         t2.menu_pid_old
    from tb_sys_menu t2
   where t2.link_url = 'purch/podtl_query_trace.ugo'