当前位置: 代码迷 >> Sql Server >> 这句SQL错在哪里了?该怎么处理
  详细解决方案

这句SQL错在哪里了?该怎么处理

热度:128   发布时间:2016-04-27 21:45:20.0
这句SQL错在哪里了?
INSERT   INTO   data.d1
SELECT   *   FROM
(
SELECT   *   FROM   data.d2
UNION   ALL
SELECT   *   FROM   data.d3
UNION   ALL
);

------解决方案--------------------
INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
UNION ALL
) t;

------解决方案--------------------
把*全部换成字段名就可以了
------解决方案--------------------
INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
);

------解决方案--------------------
INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
) t

或者

INSERT INTO data.d1
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
  相关解决方案