How to UPDATE multiple tables in Microsoft SQL using JOIN query

Sometimes the update query needs to target a complex query and therefore you will need to use this.


UPDATE 

    t1

SET 

    t1.field = value   

FROM 

    t1

    [INNER | LEFT] JOIN t2 ON join_predicate

   ..

WHERE 

    where_predicate;

Comments

Popular posts from this blog

Enable PHP opcache extension on Windows XAMPP

Black border on video created by Windows Live Movie Maker

Error code 8024001b (solved)