把一张表某一字段更新到另一张表的字段中

PDATE yzj_document_article B SET B.urlname = (SELEC urlname FROM yzj_document_article_old A WHERE A.id = B.id);