查询疑难杂症又来啦~无法在联合查询的基础上建立查询~

又要麻烦您了~

联合查询:

SELECT
员工1列统计.员工,员工1列统计.DateS, 员工1列统计.DidS,  员工1列统计.Hhid, 员工1列统计.SizeA, 员工1列统计.Num, 员工1列统计.Amount, 员工1列统计.id_Card,员工1列统计.lshid
FROM 员工1列统计
UNION ALL SELECT
员工2列统计.员工, 员工2列统计.DateS, 员工2列统计.DidS, 员工2列统计.Hhid, 员工2列统计.SizeA, 员工2列统计.Num, 员工2列统计.Amount, 员工2列统计.id_Card,员工2列统计.lshid
FROM 员工2列统计;

查询1

SELECT Left([sp_idstr],4) AS 员工, LshList.DateS, LshList.DidS, MxList.Hhid, MxList.SizeA, Sum(MxList.Num) AS num, Sum(MxList.Amount) AS Amount, MxList.id_Card, MxList.Lshid
FROM LshList INNER JOIN MxList ON LshList.Lshid = MxList.Lshid
WHERE (((LshList.T_id)=3))
GROUP BY Left([sp_idstr],4), LshList.DateS, LshList.DidS, MxList.Hhid, MxList.SizeA, MxList.id_Card, MxList.Lshid
HAVING (((LshList.DateS) Between "2010-07-23" And "2020-12-31") AND ((LshList.DidS)<>"00"));

查询2:

SELECT Right([sp_idstr],4) AS 员工, LshList.DateS, LshList.DidS, MxList.Hhid, MxList.SizeA, Sum(MxList.Num) AS Num, Sum(MxList.Amount) AS Amount, MxList.id_Card, MxList.Lshid
FROM LshList INNER JOIN MxList ON LshList.Lshid = MxList.Lshid
WHERE (((LshList.T_id)=3))
GROUP BY Right([sp_idstr],4), LshList.DateS, LshList.DidS, MxList.Hhid, MxList.SizeA, MxList.id_Card, MxList.Lshid
HAVING (((LshList.DateS) Between "2010-07-23" And "2020-12-31") AND ((LshList.DidS)<>"00"));