SQL

INSERT INTO target_table (column1, column2, column3) SELECT source_column1, source_column2, source_column3 FROM source_table WHERE condition;