Resolved sql statement

I have 2 tables in an SQL database:
table 1: CountryCodes with 3 rows: CountryName, CountryCode, PhonePrefix
table 2: PhoneCodes with 2 rows: CountryName, PhonePrefix

What I want to do is copy all records
from table PhoneCodes row PhonePrefix
to table CountryCodes row PhonePrefix
if the CountryName row in both tables are equal

Can anyone help me create an sql script that do just that?

 

SQL UPDATE statement should do the trick.

SQL UPDATE Statement

 

Worked like a charm!
Much appreciated for the quick response.