You should update from 'Part' then join the other two tables.

But Jeff's answer is much better 😀

This is known as dynamic SQL.

It can be useful for reports which use Pivots, where the number of columns depends on a date range supplied by the user for example.