如何设置一个列值等于另一个表中的值?

I am trying to figure out how to update a row in one table, setting a column value equal to a value in a different table. Here's an example:I am trying to figure out how to update a row i