access怎样取多个count(*)

select count(*) as count1 from tbl where....

select count(*) as count2 from tbl where....


怎样把两个句子合并成一个查询？

---

select count(*) as count1 from tbl where....

select count(*) as count2 from tbl where....

这两个结果不是一样吧？都是从 tbl 中取记录数？

---

select count(iif(条件1,1)) as count1,count(iif(条件2,1)) as count2 from tbl

---

我说的是同时取，就是在一条语句里取到。

select
(select count(*) as count1 from tbl where....),
(select count(*) as count2 from tbl where.... )

在sqlserver里可以取到。access里不行。

---

select * from
(select count(*) as count1 from A ) A1,
(select count(*) as count2 from A ) B1

---

select A1.count1,B1.count2  from
(select count(*) as count1 from A) A1,
(select count(*) as count2 from B) B1

---

select
(select count(*) as count1 from tbl where....),
(select count(*) as count2 from tbl where.... )

这个语句同样ACCESS中也可以啊。