Sqla="Select count(ArticleName) as TotalArticle From Article,count(ArticleName) as TodayArticle From Article Where DateDiff('d',ArticleTime,now)>0 and DateDiff('d',ArticleTime,now)<1"

帮忙看看哪里出错了。。。。

Sqla="Select count(ArticleName) as TotalArticle From Article
sqlb="select count(ArticleName) as TodayArticle From Article Where DateDiff('d',ArticleTime,now)>0 and DateDiff('d',ArticleTime,now)<1"
两个分别用可以显示出来。。就是不知道如何把他们只用一个SQL语句

Sqla="Select count(*) as TotalArticle,count(ArticleName) as TodayArticle From Article Where DateDiff('d',ArticleTime,now)>0 and DateDiff('d',ArticleTime,now)<1"
这样也不行。。
我是想实现第一次统计所有.第二次统计当天的..请指点..谢谢!!

还是要谢谢你。。
那我就先分开写。。等有好方法在改一下。