问如何使用其他表中的值更新表

EN

update nol_art 
    set  
        CENA_IZM=coalesce(xd.IZM, CENA_IZM) 
    from 
        #tmpIzm xd 
        join nol_art a on a.ART_ID=xd.ID_ART 
    where  
        a.ART_ID=xd.ID_ART 

UPDATE 
        document
    SET 
        department =    
            (SELECT departmentId
                FROM 
                department
            WHERE 
                document.base_child = document.base_child AND
                document.folder_child = document.folder_child)
    WHERE
        EXISTS 
        ( SELECT * FROM department 
                    WHERE department.base_child = department.base_child 
                     AND  department.folder_child = department.folder_child);