SELECT t1.*,SUM(t2.portal_count) FROM 表1 AS t1 LEFT JOIN 表2 AS t2 ON t1.websiteid = t2.websiteid WHERE t2.datetime BETWEEN '2014-10-15 00:00:00' AND '2014-10-15 23:59:59' GROUP t1.websiteid 试试这个呢,这里的“表1”、“表2”需要替换成你数据库中的表名
select sum(portal_count)portal_count from a,b where a.websiteid = b.websiteid and b.datetime >= '2014-10-15' and b.datetime < '2014-10-16'
56,679
社区成员
56,709
社区内容
加载中
试试用AI创作助手写篇文章吧