在Access中组合多个查询，以便在单个表中的不同字段中显示数据。

Question

我有两个问题，我想加入到一起。Union选项将无法工作，因为我希望在不同的字段中显示这些值。第一个查询是

 SELECT Outage.DISTRICT, Count(Outage.DISTRICT) AS CountOfDISTRICT
 FROM Outage LEFT JOIN [Site ID gets generated] ON Outage.[Site ID]=[Site ID gets     generated].[Site ID]
 GROUP BY Outage.DISTRICT;

第二个查询是

SELECT Outage.DISTRICT, Count(Outage.[Site ID]) AS [CountOfSite ID]
FROM Outage
GROUP BY Outage.DISTRICT;

我尝试了下面的代码，但在第一个查询中出现了语法错误(缺少操作符)

SELECT Outage.DISTRICT,
(SELECT  Count(Outage.[Site ID]) AS [CountOfSite ID] FROM Outage),
(SELECT  Count(Outage.DISTRICT) AS CountOfDISTRICT FROM Outage LEFT JOIN [Site ID gets generated] ON Outage.[Site ID]=[Site ID gets generated].[Site ID])
GROUP BY Outage.DISTRICT;

如果也给出一个解释的话，这将是非常有帮助的，因为我对访问和尝试从零开始学习它是非常陌生的。

Answer 1

您可以将这两个查询连接在一起，以获得它们的列：

select
  sq1.DISTRICT
, sq1.CountOfDISTRICT
, sq2.[CountOfSite ID]
from (
  ... your first query here ...
) as sq1
inner join (
  ... your second query here ...
) as sq2
on sq1.DISTRICT = sq2.DISTRICT

需要记住的是，联合用于垂直连接表/查询，而联接用于横向连接表/查询。