Update Query with a JOIN Statement

I found something useful when I am trying to update columns in a master table (tbl1) from data in a temp table (tbl2). These updates can be done by making a query to update a table by doing INNER JOIN.Below is the example of a joined update query:UPDATE tbl1SET field_name = B.field_nameFROM tbl1 AINNER JOIN tbl2 BON A.ID = B.IDHope this hel...