i have two temporary tables and a main table

the first temporary table is called TEMP_Open, and the second temporary table is called TEMP_Daily, while the main table is called MET_DATA. MET_DATA table has columns named Main_orders, Name, Address, State, Created, Order_names, Ref_orders

TEMP_Open has columns named Main_orders, Name, Address, State, Created_on, order_names, ref_orders

TEMP_Daily has the same column names as TEMP_Open (Main_orders, Name, Address, State, Created_on, Order_names, Ref_orders).

I want to replace all the data in MET_DATA by doing an INSERT INTO. The only information I need from TEMP_Open is Created_on, but from TEMP_DAILY I need columns Main_orders, Name, Address, State, Order_names, Ref_orders.