使用案例

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;