Question

ASP数据库查询问题，帮下忙~~ 急！！！

下面这个是两个表的对接查询，查询的是本周的票数排行，是正确的。
现在要改一下，查询出时间在 2010年8月12日到2010年8月18日的票数排行，也就是时间段的票数排行，谢谢！
lr3="select user_id,lc,ad,allnum,tgid, count(*) as aaa from votetime a, lyb b where a.user_id = b.id and datediff('d',submit_time,date())<weekday(now,2) and datediff('d',submit_time,date())>-1 group by user_id,lc,ad,allnum,tgid order by count(*) desc "

Answer 1

lr3="select user_id,lc,ad,allnum,tgid, count(*) as aaa from votetime a, lyb b where a.user_id = b.id and datediff('d',submit_time,'2010-8-12')<=0 and datediff('d',submit_time,'2010-8-18')>=0 group by user_id,lc,ad,allnum,tgid order by count(*) desc "