select count(newsdate),count(edition),其他你要取出的字段
from record,rec_user
where ru_iuser='mgq'
and date_format(ru_idate,'%c/%e/%Y')='2/9/2006'
and ru_id=recid
group by newsdate,edition
order by newsdate,edition
from record,rec_user
where ru_iuser='mgq'
and date_format(ru_idate,'%c/%e/%Y')='2/9/2006'
and ru_id=recid
group by newsdate,edition
order by newsdate,edition
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货