How to merge the contents of two tables with exactly the same structure into a single table, SQL statements

 Tags: SQL merge data2013-08-21 10:41 489 people read Comments (0) favorite reports Classification:Oracle Database (DB)

SELECT *
into new table name
From (SELECT * FROM T1 UNION ALL SELECT * from T2)

This statement can be implemented to append the merged data to a new table.

Do not merge duplicate data
SELECT * FROM T1 UNION ALL SELECT * FROM T2

Merge duplicate data
SELECT * FROM T1 Union SELECT * FROM T2

Two tables, table 1 table 2
If you want to incorporate table 1 data into table 2, use the following statement

Insert INTO Table 2 (Field 1, Field 2) Select field 1, Field 2 from B1

Note that the field names must be written clearly, and the automatic numbering is not allowed to be written in, to merge the AutoNumber field must rewrite an algorithm one record to add in

1 INSERT INTO B1 select * from B2
2 Select * Into NewTable from (SELECT * FROM B1 UNION ALL SELECT * from B2)

How to merge the contents of two tables with exactly the same structure into a single table, SQL statements