选择使用联合查询 [英] SELECT INTO USING UNION QUERY

问题描述

我想使用以下查询在 SQL Server 中创建一个新表.我无法理解为什么此查询不起作用.

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.

查询 1:作品

SELECT * FROM TABLE1
UNION
SELECT * FROM TABLE2 

查询 2:不起作用.错误:<代码>消息 170，级别 15，状态 1，第 7 行第 7 行:')' 附近的语法不正确.

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
)

谢谢！

推荐答案

您必须为 SQL Server 中的派生表定义表别名:

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"是本例中的表别名.

"x" is the table alias in this example.

这篇关于选择使用联合查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！