-- UNION 이 아닌 UNION ALL로 변경하였습니다. SELECT '0'AS chk ,2 AS chkg_snd ,hdn_snd ,hdn_dscd ,hdn_lvl ,hrk_hdn_snd ,hdn_cts ,chkg_mth_cts ,srt_sqn FROM TB_AIB_CP_FC_CHKLST_BC a WHERE NOT EXISTS (SELECT 1 FROM TB_AIB_CP_FC_CK_CL_DL b WHERE '2' = b.chkg_snd AND a.hdn_snd = b.hdn_snd AND a.hdn_dscd = b.hdn_dscd AND a.hdn_lvl = b.hdn_lvl AND a.hrk_hdn_snd = b.hrk_hdn_snd AND a.hdn_cts = b.hdn_cts AND a.chkg_mth_cts= b.chkg_mth_cts AND a.srt_sqn = b.srt_sqn) UNION ALL '1'AS chk ,chkg_snd ,hdn_snd ,hdn_dscd ,hdn_lvl ,hrk_hdn_snd ,hdn_cts ,chkg_mth_cts ,srt_sqn FROM TB_AIB_CP_FC_CK_CL_DL