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*/