这个查询不起作用:

WITH a AS 
(SELECT 1 AS c1)
SELECT
    *
FROM
    a 


UNION ALL

WITH b AS 
(SELECT 1 AS c1)
SELECT
    *
FROM
    b

你能帮忙吗？

真正的查询使用表，但在示例中不是必需的。

非常感谢

最佳答案

;WITH a AS 
(SELECT 1 AS c1), 
b AS 
(SELECT 1 AS c1)
SELECT
    *
FROM
    a 
UNION ALL
SELECT
    *
FROM
    b

https://stackoverflow.com/questions/12677273/