Copy items from one table to another

I have 2 tables.
Main Serial Number
Solution_ID

They both have the following 2 fields
Log_ID
Soln_ID

Both tables contain the same information as far as LOG_ID goes.
I want to that the information in the Solution ID table Field Soln_ID and replace the number that is in the Main Serial Number table Field Soln_ID
So match up the Log_ID number and replace the Soln_ID with the one from the Solution_ID table.
Confused I am 🙂

Thank You