How to update rows value of specific column from another table's specific column?

[jmcilhinney]

First of all, do you want to add new rows or modify existing rows? If it's the latter then you need to use an UPDATE statement, not an INSERT statement.