Answers for "get value from a table an insert it with other values in another table sql"

get value from a table an insert it with other values in another table sql

INSERT INTO table1 ( column1, column2, someInt, someVarChar )
SELECT  table2.column1, table2.column2, 8, 'some string etc.'
FROM    table2
WHERE   table2.ID = 7;

get value from a table an insert it with other values in another table sql

INSERT INTO column_1 ( val_1, val_from_other_table ) 
VALUES('val_1', (SELECT  val_2 FROM table_2 WHERE val_2 = something))

create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;