[mssql] update join

반응형

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

반응형