sql="select count(article.ar_id),count(topic.topic_id) from article,topic where class_id="&request.querystring("class_id")这样写

[QYworld]

这样可以：sql="select count(article.ar_id) from article where class_id="&request.querystring("class_id")
但两个表就不行了

应该如何写？

[QYworld]

sql="select count(article.ar_id),count(topic.topic_id) from article,topic where class_id="&request.querystring("class_id")

这样写怎么不对？帮忙，谢谢 up一下

[QYworld]

sql="select (select count(ar_id) from article where class_id = " & request.querystring("class_id") & " ) as 'ArticleCount', (select count(topic_id) from topic where class_id = " & request.querystring("class_id") & " ) as 'TopicCount'"

这样写怎么得到count(ar_id)和count(topic_id)的值？

我用的是access数据库

[saucer]

sql="select (select count(ar_id) from article where class_id = " & request.querystring("class_id") & " ) as 'ArticleCount', (select count(topic_id) from topic where class_id = " & request.querystring("class_id") & " ) as 'TopicCount'"

[julyclyde]

rs("ArticleCount")
rs("TopicCount")




如果是sql="select count(article.ar_id),count(topic.topic_id) from article,topic where class_id="&request.querystring("class_id")
可以用rs(0),rs(1)

[genuis]

sql="select count(article.ar_id),count(topic.topic_id) from article,topic where article.class_id="&request.querystring("class_id")

[leonkim]

你所实现的功能是什么？