Bulk Update using join in SQL

Tweet

UPDATE WITH JOIN

 UPDATE t1
  SET t1.name = t2.empname  //copy content from one table to another
 FROM table1 t1
    INNER JOIN table2 t2 ON
        t1.id = t2.t1id