cutExpiredPointBySql.sql 422 Bytes
Newer Older
Kim Gyeongeun committed
1 2 3 4 5 6 7 8 9
UPDATE m_member M SET point_num = COALESCE(P.validPoint,0) FROM  
       (select MT.member_id,validPoint from m_member MT 
       LEFT JOIN (select SUM(point_get_num - point_use_num) validPoint,member_id from t_point_get WHERE  
           valid_flg = 1  
           GROUP BY member_id) PT 
           ON MT.member_id = PT.member_id  
       ) P 
WHERE     M.member_id = P.member_id 
      AND M.point_Num > /*point_Num*/