select t2.wlmc mc,t1.name shibie,sum(t2.yl) yl
from t1,t2
where convert(varchar(5),t2.sj,108) between t1.[begin] and [t1.end]
group by t2.wlmc,t1.name--时间存储格式要求:08:00
from t1,t2
where convert(varchar(5),t2.sj,108) between t1.[begin] and [t1.end]
group by t2.wlmc,t1.name--时间存储格式要求:08:00
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货