SELECT tmpaaa.code, sum(tmpaaa.sl), avg(tmpaaa.dj), sum(tmpaaa.jssl - tmpaaa.sl) AS tg, sum(tmpaaa.sl * tmpaaa.dj) AS syje
FROM tmpaaa, spbm, scdw
WHERE SUBSTRING(tmpaaa.code, 1, 4) = spbm.code1
AND SUBSTRING(tmpaaa.code, 5, 3) = scdw.dwbh
GROUP BY tmpaaa.code
FROM tmpaaa, spbm, scdw
WHERE SUBSTRING(tmpaaa.code, 1, 4) = spbm.code1
AND SUBSTRING(tmpaaa.code, 5, 3) = scdw.dwbh
GROUP BY tmpaaa.code
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货