daily-story

[mssql] update join

프로그래밍 2014.09.23 댓글 0 덜구

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

댓글

0