UPDATE T_Payment SET Payment_Group_No = ? WHERE (T_Payment.Payment_Type_no =        (SELECT T_Payment_type.Payment_type_no FROM T_Payment_type WHERE T_Payment_type.Payment_Group_No = ?)) AND (Payment_Date BETWEEN ? AND ?)