;with cteMemberList as (
 
 SELECT DISTINCT  MM.Sup_No, 
                                     MM.Per_Nm ,
                                     CC.CODE_NAME,
                                     ISNULL(SUM(CR.Rcpt_Amt), 0) AS IN_AMT, 
                                     MM.AMT_IN_TYPE  
     

FROM GT..tblmember  MM   
      LEFT JOIN GT..tblcard TC ON   MM.Sup_No = TC.Sup_No   
      LEFT JOIN CM..tblcode CC ON  CC.TYPE + CC.CODE = MM.AMT_IN_TYPE  
      LEFT JOIN GT..TBLCREDIT CR ON MM.SUP_NO = CR.SUP_NO  
    
     

 WHERE MM.SUP_NO IS NOT NULL
      AND MM.PER_NM IS NOT NULL 
      AND MM.REG_DT BETWEEN '00000000' AND '20131231'
      AND TC.Home_Addr1 + ' ' + TC.HOME_ADDR2 <> ''
      AND MM.CANCEL_DT = ''
      AND MM.AMT_IN_TYPE  = 'PA0718'
     
     

 GROUP BY  MM.Sup_No
                     ,MM.PblcYN
                    ,MM.spclyn
                   ,MM.Per_Nm
                   ,CC.CODE_NAME 
                    ,MM.AMT_IN_TYPE
     )     
 
SELECT Sup_No,Per_Nm,AMT_IN_TYPE,CODE_NAME,IN_AMT
FROM cteMemberList
WHERE IN_AMT = '0'

여기서 조회된 값을 가지고

MM.AMT_IN_TYPE  = 'PA0718' -> 'PA0713'으로 업데이트 할려고 하는데

 셀렉트의 ISNULL(SUM(CR.Rcpt_Amt), 0) AS IN_AMT 여기서 가져온 값 때문인지 업데이트가 안됩니다

SUM 때문인거 같은데 어찌 방법이 없겠습니까??

( ISNULL(SUM(CR.Rcpt_Amt), 0) AS IN_AMT 이것이 빠지게 되면 정확한 값이 안나와서요..ㅠ)