Updating a table based on joining another table

Update all rows in a table

Update all rows meeting a condition

Updating multiple columns in table