从其他表中查询结果并插入新表
INSERT INTO jpf_project_service (project_no,service_id,customer_id,start_time,end_time,create_id,create_time) SELECT sp.PROJECT_NO , sp.SERVICE_ID , sp.MASTER_CUSTOMER_ID, sc.START_TIME, sc.END_TIME,1,sysdate() FROM jbp_service_project sp INNER JOIN jpf_customer_service sc ON sc.CUSTOMER_ID = sp.MASTER_CUSTOMER_ID AND sc.SERVICE_ID = sp.SERVICE_ID;