Create a new table from two existing table

debugcn Published at Dev

Allen_Delon

Hello,

I need your help. I am trying to create a new table using two existing table (TABLE1 and TABLE2). I have no idea what SQL Server technique I can use to resolve this issue.

SELECT A AS A1, B AS B1, C AS C1 FROM TABLE1
Result:
        A1  B1  C1
        3   4   1
        1   2   0

SELECT E2 AS A1, F2 AS B1, G2 AS C1 FROM TABLE2
Result:
        A1  B1  C1
        4   7   1
        2   8   6

Let’s name the new table 'My_Table' which includes all data from TABLE1 and TABLE2.

SELECT * FROM My_Table
Result:
        A1  B1  C1
        3   4   1
        1   2   0
        4   7   1
        2   8   6

I want to save this table in my database and use it in the future.

Any help would be appreciated.

robdjc

You can try to use the INTO clause and a UNION of both selects.

SELECT A AS A1, B AS B1, C AS C1 
INTO My_Table
FROM TABLE1
UNION
SELECT E2 AS A1, F2 AS B1, G2 AS C1 
FROM TABLE2

Note, that a UNION will also remove duplicate records. If that is not expected, then check out UNION ALL.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-8

Comments

0 comments

From Dev

Create empty SQL table from existing table in Azure

From Dev

Adding new data from JSON to existing table

From Dev

Papyrus - Create a Table from an existing configuration

From Dev

Create new hive table from existing external portioned table

From Dev

How to create new field in view with some offset (field of table) from existing field (another field of table)?

From Dev

How to create a new table from existing table with both keys and data in SQL Server 2012 (Management Studio)?

From Dev

Create a new table based on existing table

From Dev

Creating a new table in database with description from existing table as an input

From Dev

Create a new table from two existing table

From Dev

T-SQL Add new column in existing table and fill with value from two another existing column

From Dev

Create a new aggregate collection from two existing collections?

From Dev

SQL - INSERT new row by using sum of two existing rows from same table

From Dev

Create a new table (copy of an existing) with date order

From Dev

Word 2013 - How to create a new table style from an existing table style?

From Dev

Create table from two rows, one column

From Dev

Create empty SQL table from existing table in Azure

From Dev

Cassandra - Import from CSV and create new table?

From Dev

Create table joining two existing tables in Shark Hive

From Dev

Create an HTML table from an existing array

From Dev

Create new hive table from existing external portioned table

From Dev

Need to create a new table from existing table

From Dev

Create New MySQL table with structure of existing table

From Dev

laravel - Create a new migration table with data from existing

From Dev

How to create table from existing 2 table with default value in oracle

From Dev

SQL: Create new table from old

From Dev

Create new table from old table and add 2 new columns

From Dev

create a new hive table with values from two hive tables

From Dev

insert into new table from existing table with an added new field

From Dev

Is it possible to create a new table from an unpivot results?

Related Related

Article