SQL 怎么连接两个 查询结果？？？？？？
with SumTable as (
SELECT Count(b.OptionItemsName) as SubmitSum ,b.OptionItemsName
FROM ArchivesReportInfo a inner JOIN OptionItems b
ON a.OptionTypeID = b.OptionItemsID
group by b.OptionItemsName
)
with AdoptTable as (
SELECT Count(b.OptionItemsName) as SubmitSum ,b.OptionItemsName
FROM ArchivesReportInfo a inner JOIN OptionItems b
ON a.OptionTypeID = b.OptionItemsID
where Examine = 1
group by b.OptionItemsName
)
select *
from SumTable a inner JOIN AdoptTable b
on a.OptionItemsName = b.OptionItemsName
像上面这么写报错了
如果此语句是公用表表达式、xmlnamespaces 子句或者更改跟踪上下文子句，那么前一个语句必须以分号结尾。
求达人
[解决办法]
;with SumTable as (
SELECT Count(b.OptionItemsName) as SubmitSum ,b.OptionItemsName
FROM ArchivesReportInfo a inner JOIN OptionItems b
ON a.OptionTypeID = b.OptionItemsID
group by b.OptionItemsName
),
AdoptTable as (
SELECT Count(b.OptionItemsName) as SubmitSum ,b.OptionItemsName
FROM ArchivesReportInfo a inner JOIN OptionItems b
ON a.OptionTypeID = b.OptionItemsID
where Examine = 1
group by b.OptionItemsName
)
select *
from SumTable a inner JOIN AdoptTable b
on a.OptionItemsName = b.OptionItemsName
[解决办法]
with SumTable as (
SELECT Count(b.OptionItemsName) as SubmitSum ,b.OptionItemsName
FROM ArchivesReportInfo a inner JOIN OptionItems b
ON a.OptionTypeID = b.OptionItemsID
group by b.OptionItemsName
),
AdoptTable as (
SELECT Count(b.OptionItemsName) as SubmitSum ,b.OptionItemsName
FROM ArchivesReportInfo a inner JOIN OptionItems b
ON a.OptionTypeID = b.OptionItemsID
where Examine = 1
group by b.OptionItemsName
)
select *
from SumTable a inner JOIN AdoptTable b
on a.OptionItemsName = b.OptionItemsName
