select c.id as id ,c.UnitName as sname ,count(a.id) as num from res a
left join userinfo b on b.id=a.ImporterID
left join unitinfo c on b.UnitID=c.id where c.id in(1,2,4,5,6,7,8,9,10);
left join userinfo b on b.id=a.ImporterID
left join unitinfo c on b.UnitID=c.id where c.id in(1,2,4,5,6,7,8,9,10);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货