Syntax Error with my SQL Create Table As [duplicate]

Question

I am trying to create a new table in Microsoft SQL Server Management Studio based on two existing tables.

When I execute the query below, I get an error saying that there is an:

Incorrect syntax near the keyword 'SELECT'.

SQL code:

CREATE TABLE NEW_TABLE AS
 SELECT OLD_TABLE.A
    , OLD_TABLE.B
    , OTHER_OLD_TABLE.C
 FROM OLD_TABLE
 INNER JOIN OTHER_OLD_TABLE
 ON OLD_TABLE.A = OTHER_OLD_TABLE.D;

I looked at various other problems, but could not find a solution to mine. Do you have any idea what could be wrong with the syntax?

SQL Server's syntax is SELECT ... INTO new table FROM.... Your example is representative of MySQL's syntax. — Michael Berkowski
– Michael Berkowski, Commented Apr 20, 2015 at 17:28
Thank you, I did not realise. Apologies for the duplicate post - definitely was a result of my confusion. — Smile5.09
– Smile5.09, Commented Apr 21, 2015 at 8:35
No need to apologize . The community is here to point you to good answers. They may already exist. — Michael Berkowski
– Michael Berkowski, Commented Apr 21, 2015 at 10:43

Thiha Zaw · Accepted Answer · 2015-04-20 17:27:35Z

8

Alternatively, you can use SELECT * INTO new_table statement just like this.

SELECT OLD_TABLE.A
, OLD_TABLE.B
, OTHER_OLD_TABLE.C INTO NEW_TABLE
FROM OLD_TABLE
INNER JOIN OTHER_OLD_TABLE
ON OLD_TABLE.A = OTHER_OLD_TABLE.D;

this statement will also create a new table as you required.

answered Apr 20, 2015 at 17:27

Thiha Zaw

8362 gold badges10 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error with my SQL Create Table As [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related