0 - 1 of 1 tags for update with join

Hi,
I am having trouble with writing an update statement. Below is the SQL code to understand basic update I need: