update R10 set r10.pname = r09.pname from r10 inner join r09 on r10.kod = r09.kod
SQL и оператор JOIN