select count(*) 的问题

来源：百度知道 编辑：UC知道 时间：2024/06/14 02:50:48
Access数据库，有多个表，查每个表有多少条记录写select count(*) from 表1，select count(*) from 表2，select count(*)，select count(*) from 表3，我的问题是，可以把查询每个表的单独的句子合成一个吗？就是用一句来查询N个表每个表的记录数。谢谢！
二楼说的没错，按一楼的方法，是乘积。三楼的方法我去试试。
三楼的方法没成功，不知道为什么，三个表分别是User Class Article 我把三个名字填进去这样：
select count(KS_User.*) as cout1,b.cout2,b.cout3
from KS_User,
(select count(KS_Class.*) as cout2,a.cout3
from KS_Class,(select count(KS_Article.*) as cout3 from KS_Article) as a) as b
提示：语法错误，在'count(KS_User.*)'中
再改成这样：
select count(*) as cout1,b.cout2,b.cout3
from KS_User,
(select count(*) as cout2,a.cout3
from KS_Class,(select count(*) as cout3 from KS_Article) as a) as b
错误提示：试图执行的查询中不包含作为合计函数一部分的特定表达式'cout3'
改成
select count(KS_User) as cout1,b.cout2,b.cout3
from KS_User,
(select count(KS_Class) as cout2,a.cout3
from KS_Class,(select count(KS_Article) as cout3 from KS_Article) as a) as b
错误一样

以下SQL文可以实现你的目的

select count(表1.*) as cout1,b.cout2,b.cout3
from 表1,
(select count(表2.*) as cout2,a.cout3
from 表2,(select count(表3.*) as cout3 from 表3) as a) as b

不好意思,以上的回答我没有跑过,行不通.呵呵.
下边的语句才是你需要的.
select count(*) as cout1,(select count(*) from KS_Class) as cout2,(select count(*) from KS_Article) as cout3 from KS_User
你再试下吧.

当然可以。。试试下面：
select count(*) from 表1，表2，表3

不可以,这样只能够显示3个表记录数的乘积

顶这个,我看过了 可以用
select count(*) as cout1,(select count(*) from KS_Class) as cout2,(select count(*) from KS_Article) as cout3 from KS_User