Insert Query for table

How to add data from one table to another table with new data in SQ开发者_如何学CL?

---

You'd use an SQL INSERT INTO SELECT like so:

INSERT INTO "table1" ("column1", "column2", ...)
SELECT "column3", "column4", ...
FROM "table2"

You can find more info here: http://www.1keydata.com/sql/sqlinsert.html

---

Don't have enough points to comment, but lomaxx's query is functioning correctly @shanks. If you run an insert query again, you will get duplicates for each time the query is run.

---

INSERT INTO "table1" ("column1", "column2", ...)
SELECT "column3", "column4", ...
FROM "table2"
minus
SELECT "column1", "column2", ...
FROM "table1"