读书人

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

发布时间: 2012-01-20 18:53:53 作者: rapoo

这句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

读书人网 >SQL Server

热点推荐