sql

update log_send_mail_01 s, (select w.trans_id,GROUP_CONCAT(w.recv_user_name) con_name from log_deliver_mail_01 w
group by w.trans_id ) t set s.recv_list_name=t.con_name where s.trans_id=t.trans_id;