CODE EXAMPLE FOR SQL

how to save result of sqlite query in a table

INSERT INTO `new_tbl` SELECT * FROM table_1 LEFT JOIN table_2 ON table_1.Temp = table_2.Temp;