SELECT A.Maunfacture, A.malfunction, Count([malfunction])+DCount("malfunction","B","[Manufacture]='" & [Maunfacture] & "' and [malfunction]='" & [malfunction] & "'") AS 两表相加数量
FROM A
GROUP BY A.Maunfacture, A.malfunction
UNION SELECT Manufacture, malfunction, count(malfunction) AS 合计
FROM [SELECT c.Manufacture, c.malfunction
FROM B AS c
WHERE c.malfunction not in (select malfunction from A where Maunfacture=c.Manufacture)]. AS [%$##@_Alias]
GROUP BY Manufacture, malfunction;
SELECT A.Maunfacture, A.malfunction, Count([malfunction])+DCount("malfunction","B","[Manufacture]='" & [Maunfacture] & "' and [malfunction]='" & [malfunction] & "'") AS 两表相加数量
FROM A
GROUP BY A.Maunfacture, A.malfunction
2. 求出B表有而A表没有的项目
SELECT Manufacture, malfunction, count(malfunction) AS 合计
FROM [SELECT c.Manufacture, c.malfunction
FROM B AS c
WHERE c.malfunction not in (select malfunction from A where Maunfacture=c.Manufacture)]. AS [%$##@_Alias]
GROUP BY Manufacture, malfunction
SELECT [Motor Overhaul].[Manufacturer/制造商], [Motor Overhaul].[Malfunction Performance/故障现象], Count([Motor Overhaul].[Malfunction Performance/故障现象])+DCount("[Malfunction Performance/故障现象]","Motor Rewinding","[Motor Rewinding].[Manufacturer/制造商]='" & [Motor Overhaul].[Manufacturer/制造商] & "' and [motor Rewinding].[Malfunction Performance/故障现象]='" & [Motor Overhaul].[Malfunction Performance/故障现象] & "'") AS 两表相加数量
FROM [Motor Overhaul]
GROUP BY [Motor Overhaul].[Manufacturer/制造商], [Motor Overhaul].[Malfunction Performance/故障现象];
UNION SELECT [motor Rewinding].[Manufacturer/制造商], [motor Rewinding].[Malfunction Performance/故障现象], Count([motor Rewinding].[Malfunction Performance/故障现象]) AS 合计
FROM [SELECT [C].[Manufacturer/制造商],[C].[Malfunction Performance/故障现象]
FROM [Motor Rewinding] AS [C]
WHERE [C].[Malfunction Performance/故障现象] not in ( SELECT [Malfunction Performance/故障现象] from [Motor Overhaul] WHERE [Motor Overhaul].[Manufacturer/制造商]= [C].[Manufacturer/制造商])]. AS [%$##@_Alias]
GROUP BY [motor Rewinding].[Manufacturer/制造商],[motor Rewinding].[Malfunction Performance/故障现象];