SELECT n.netname,c.dutybegintm,(SELECT count(1) FROM mem_memberbaseinfo b,netb_baseinfo n WHERE n.id=b.netbid and b.createTm<= '2009-08-18 00:00:00' ) as total,
(SELECT count(1) FROM mem_memberbaseinfo b,netb_baseinfo n WHERE n.id=b.netbid and b.createTm<= '2009-08-18 00:00:00' and createTm>='2009-08-01 00:00:00') as newtotal ,c.pcscount
FROM changedotyflow c ,netb_baseinfo n,mem_memberbaseinfo b
WHERE c.netbid=n.id and n.id=b.netbid
(SELECT count(1) FROM mem_memberbaseinfo b,netb_baseinfo n WHERE n.id=b.netbid and b.createTm<= '2009-08-18 00:00:00' and createTm>='2009-08-01 00:00:00') as newtotal ,c.pcscount
FROM changedotyflow c ,netb_baseinfo n,mem_memberbaseinfo b
WHERE c.netbid=n.id and n.id=b.netbid
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货