[求助]ACCESS中两个查询如何合并为一个?

member99999

各位,

如何将以下两个查询合并为一个? 谢谢指点指点...

1)  A

SELECT B.1, B.2, B.3
FROM B
GROUP BY B.1, B.2, B.3
HAVING (((Count(B.1))>=1));


2)  C

SELECT D.4, D.5, D.6, D.7, D.8, D.9, D.10, D.11, D.1, D.12, D.13, E.14
FROM (D INNER JOIN A ON D.1=A.1) INNER JOIN E ON A.2=E.2
WHERE (((D.6)="A") AND ((D.8)="AP") AND ((D.11)>=#1/1/2005#));

一点通

请参考一下这个例子

http://www.office-cn.net/forum.php?mod=viewthread&tid=9226

member99999

谢谢管理员!

kapqxy0

谢谢

rym9401

顶下

asd280

顶下下