insert into table with id of another table code example Example: create table and insert values from another table CREATE TABLE new_table AS SELECT * FROM old_table;