INSERT INTO kennel_alliance( id, member_code, project, combo, operator, pay_amount, start_date, end_date, create_by, create_date, update_by, update_date, remarks, del_flag ) SELECT id, userid, cku_project, cku_package, cku_service, cku_payamount, cku_lmstarttime, cku_lmendtime, 1, SYSDATE(), 1, SYSDATE(), cku_lmbz, 0 FROM dbo.cku_kennel_qslm