update subscr_messages, (select m.message_id midd, m.replies from messages m inner join subscr_messages s on m.message_id=s.message_id) r set subscr_messages.last_read_rid=r.replies where subscr_messages.message_id=r.midd;