sql server将几个结构相同的表合并到一个新表中一直报错

[studentdsx]

如下：

Select * INTO ALLCommuteOD from (SELECT * FROM [ICData].[dbo].[CommuteOD1]
UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD2]
UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD3]
UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD4]
UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD5]
)

[二月十六]

报什么错？检查一下表结构，字段类型等是否完全一致

[LongRui888]

报的什么错。

[studentdsx]

表结构一致，报错')'附近有错误

[二月十六]

引用 3 楼 studentdsx 的回复:

表结构一致，报错')'附近有错误

这样写

SELECT  *
INTO    ALLCommuteOD
FROM    ( SELECT    *
          FROM      [ICData].[dbo].[CommuteOD1]
          UNION ALL
          SELECT    *
          FROM      [ICData].[dbo].[CommuteOD2]
          UNION ALL
          SELECT    *
          FROM      [ICData].[dbo].[CommuteOD3]
          UNION ALL
          SELECT    *
          FROM      [ICData].[dbo].[CommuteOD4]
          UNION ALL
          SELECT    *
          FROM      [ICData].[dbo].[CommuteOD5]
        ) t

[顺势而为1]

后面要加个别名吧 Select * INTO ALLCommuteOD from (SELECT * FROM [ICData].[dbo].[CommuteOD1] UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD2] UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD3] UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD4] UNION ALL SELECT * FROM [ICData].[dbo].[CommuteOD5] ) a

[学海无涯-回头是岸]

加表别名。。。