how do I copy values from one table column to another table column

Question

I have two tables Model and Charter.

I have to update new attributes to charter table with is CHAR_WAIT_CHG that has numeric data type with ALTER and add it. The Model table has MOD_WAIT_CHG which has numeric data type and has values $100,$50, and $75. I do not see any matching columns in both tables.

The values in MOD_WAIT_CHG should be copied into the column in Charter table. But I am having very hard time implementing it. Please help

My sql statement is

UPDATE CHARTER

SET CHAR_WAIT_CHG = MOD_WAIT_CHG FROM MODEL

WHERE CHARTER.MOD_CODE = MODEL.MOD_CODE

Answer 1

INSERT INTO CHAR_WAIT_CHG

SELECT [column name] FROM MOD_WAIT_CHG