how to transform one table based on values in another table

I have a source table to "clean up".  In particular, there are some bad values in a certain column.  The correct values are stored in another table.  The source table is pretty small (~1k rows), and ...