나머지는 tlf_point를 사용합니다

SELECT  j.jehyu_cd as jehyu_cd, j.jehyu_name as jehyu_name, m.merch_no as merch_no, m.sangho as sangho, m.saup_no as saup_no,

             m.merch_rank as merch_rank, m.ceo as ceo, m.regi_date as regi_date, m.bl_cd as bl_cd,

             sum(decode(tran_cd,'M1',nvl(auth_amt,0),'U1',nvl(auth_amt,0),'H1',nvl(auth_amt,0),0))-sum(decode(tran_cd,'M2',nvl(auth_amt,0),'H2',nvl(auth_amt,0),0)) as save_amt,

             sum(decode(tran_cd,'M1',1,'U1',1,0)) as save_cnt,

             sum(decode(tran_cd,'M1',nvl(save_pnt,0),0)) as save_pnt,

             sum(decode(tran_cd,'M3',1,0)) as use_cnt,

             sum(decode(tran_cd,'M3',nvl(save_pnt,0),0)) as use_pnt, 

             sum(decode(tran_cd,'M1',nvl(save_pnt,0),0)) - sum(decode(tran_cd,'M2',nvl(save_pnt,0),0)) 

             - sum(decode(tran_cd,'M3',nvl(save_pnt,0),0)) + sum(decode(tran_cd,'M4',nvl(save_pnt,0),0))

             - sum(decode(tran_cd,'U3',nvl(save_pnt,0),0)) - sum(decode(tran_cd,'M9',nvl(save_pnt,0),0)) 

             + sum(decode(tran_cd,'M1',decode(status_cd,'00',nvl(add_save_pnt,0),0), 'H1',decode(status_cd,'00',nvl(add_save_pnt,0),0),0)) as remain_pnt

from  jehyu_master j, merch_master m, tlf_point t

WHERE  j.jehyu_cd = m.jehyu_cd AND t.merch_no(+) = m.merch_no

group by  j.jehyu_cd, j.jehyu_name, m.merch_no, m.sangho, m.saup_no, m.merch_rank, m.ceo, m.regi_date, m.bl_cd

이렇게 실행하면 제휴사코드 810을 제외하고 나머지 제휴사의 가맹점별 포인트사용여부들을 출력해야되나 810 가맹점도 나옵니다 테이블은 분명 따로되어있습니다

SELECT  j.jehyu_cd as jehyu_cd, j.jehyu_name as jehyu_name, m.merch_no as merch_no, m.sangho as sangho, m.saup_no as saup_no,