[mssql] update join

update tableA 
    set col = B.col
    from tableA as A WITH (NOLOCK)
        inner join tableB as B WITH (NOLOCK)
            on ...
     where ...