How can I do an UPDATE statement with JOIN in SQL Server?

I need to update this table in SQL Server with data from its ‘parent’ table, see below:

SQL update query using joins

I have to update a field with a value which is returned by a join of 3 tables.