select b.area,sum(case when b.tel_area=substr(a.tel_no,1,4) or b.tel_area=substr(a.tel_no,1,5) then 1 else 0 end) cout,sum(case when b.tel_area=substr(a.tel_no,1,4) or b.tel_area=substr(a.tel_no,1,5) then num else 0 end) total_num
from a,b
group by c.
from a,b
group by c.
from a,b
group by b.area
所以不支持CASE WHEN
大家还有别的方法吗?
select b.area,sum(case when (b.tel_area=substr(a.tel_no,1,4) or b.tel_area=substr(a.tel_no,1,5)) then 1 else 0 end) cout,sum(case when (b.tel_area=substr(a.tel_no,1,4) or b.tel_area=substr(a.tel_no,1,5)) then num else 0 end) total_num
from a,b
group by b.area
FROM a, b
WHERE a.tel_no LIKE b.tel_no || '%'
GROUP BY b.tel_area;
也谢谢sbaz(万神渡劫)