insert into
fh_fs_report_file(file_name,file_type,file_save_path,file_create_date,report_total_record_num, file_feedback_flag,
file_feedback_record_num,file_enter_record_num,file_enter_rate,report_org_cd,file_backup_path,file_no,gather_info_id)
values(select cfrf.file_name,cfrf.file_type,cfrf.file_save_path,cfrf.file_create_date,cfrf.report_total_record_num,
cfrf.file_feedback_flag,cfrf.file_feedback_record_num,cfrf.file_enter_record_num,cfrf.file_enter_rate,cfrf.report_finance_cd,cfrf.file_backup_path,cfrf.file_no,
cfrf.gather_file_name
from c_fs_report_file cfrf,c_so_report_config src
where
cfrf.report_finance_cd = src.report_org_cd
and src.whether_move_report_file='1'
and not exists (select 1 from fh_fs_report_file ffrf where ffrf.file_name = cfrf.file_name)) 找了好久啦 都看眼花了,在查询的时候是可以的,但就是插入不行,不知道哪里有错,请各位大侠帮帮忙,谢谢啦
我多加了values
insert into
fh_fs_report_file(file_name,file_type,file_save_path,file_create_date,report_total_record_num, file_feedback_flag,
file_feedback_record_num,file_enter_record_num,file_enter_rate,report_org_cd,file_backup_path,file_no,gather_info_id)
select cfrf.file_name,cfrf.file_type,cfrf.file_save_path,cfrf.file_create_date,cfrf.report_total_record_num,
cfrf.file_feedback_flag,cfrf.file_feedback_record_num,cfrf.file_enter_record_num,cfrf.file_enter_rate,cfrf.report_finance_cd,cfrf.file_backup_path,cfrf.file_no,
cfrf.gather_file_name
from c_fs_report_file cfrf,c_so_report_config src
where
cfrf.report_finance_cd = src.report_org_cd
and src.whether_move_report_file='1'
and not exists (select 1 from fh_fs_report_file ffrf where ffrf.file_name = cfrf.file_name)这样可以通过,谢谢了
fh_fs_report_file(file_name,file_type,file_save_path,file_create_date,report_total_record_num, file_feedback_flag,
file_feedback_record_num,file_enter_record_num,file_enter_rate,report_org_cd,file_backup_path,file_no,gather_info_id)
values(select cfrf.file_name,cfrf.file_type,cfrf.file_save_path,cfrf.file_create_date,cfrf.report_total_record_num,
cfrf.file_feedback_flag,cfrf.file_feedback_record_num,cfrf.file_enter_record_num,cfrf.file_enter_rate,cfrf.report_finance_cd,cfrf.file_backup_path,cfrf.file_no,
cfrf.gather_file_name
from c_fs_report_file cfrf,c_so_report_config src
where
cfrf.report_finance_cd = src.report_org_cd
and src.whether_move_report_file='1'
and not exists (select 1 from fh_fs_report_file ffrf where ffrf.file_name = cfrf.file_name))