sql - UNION ALL 之后的 CTE

Question

这个查询不起作用:

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


UNION ALL

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

你能帮忙吗？

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

非常感谢

Answer 1

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