select * from (
select 0 charge,0 bill_counts,operation_type, 0 payment_method,
sum(case when operation_type in('001') and payment_method in('11') then charge else 0 end) in_cast from staff_accth group by operation_type ) t
where t.in_cast='0' order by operation_type;
select 0 charge,0 bill_counts,operation_type, 0 payment_method,
sum(case when operation_type in('001') and payment_method in('11') then charge else 0 end) in_cast from staff_accth group by operation_type ) t
where t.in_cast='0' order by operation_type;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货