SELECT INTO USING UNION QUERY

Question

I want to create a new table in SQL Server with the following query  I am unable to understand why this query doesn t work   Query1  Works  SELECT   FROM TABLE1 UNION SELECT   FROM TABLE2    Query2  Does not Work   Error  Msg 170  Level 15  State 1  Line 7 Line 7  Incorrect syntax near       SELECT   INTO  NEW TABLE  FROM   SELECT   FROM TABLE1 UNION SELECT   FROM TABLE2     Thanks

User · Accepted Answer

You have to define a table alias for a derived table in SQL Server:

SELECT x.* 
  INTO [NEW_TABLE]
  FROM (SELECT * FROM TABLE1
        UNION
        SELECT * FROM TABLE2) x

"x" is the table alias in this example.

User · Answer

INSERT INTO  Temp1 SELECT val1  val2  FROM TABLE1  UNION SELECT val1  val2 FROM TABLE2

User · Answer

Here s one working syntax for SQL Server 2017   USE   lt yourdb-name gt   GO  SELECT   INTO NEWTABLE  FROM  lt table1-name gt  UNION ALL SELECT   FROM  lt table2-name gt

User · Answer

select   into new table from table A UNION Select    From table B   This only works if Table A and Table B have the same schemas

User · Answer

You can also try   create table new table as select   from table1 union select   from table2

[sql] SELECT INTO USING UNION QUERY

Examples related to sql

Examples related to sql-server

Examples related to tsql

Examples related to union

Examples related to derived-table