select count(table1.table1_01) as total from table1 inner join table2 on table1.table1_01=table2.table2_01 where table1.table1_09='".$Session_name."' and (table1.table1_01 like 'J62%' or table1.table1_01 like 'L62%' or table1.table1_01 like 'P62%') and table2_121<>'Y' group by table1.table1_01
select count(table1.table1_01) as total from table1 inner join table2 on table1_01=table2_01 where table1_09='".$Session_name."' and (table1_01 like 'J62%' or table1_01 like 'L62%' or table1_01 like 'P62%') and table2_121<>'Y'应该直接用count(*) as total 就可以了.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货