我有两个正确的mysql查询如下:
select
count(aboneler.abone_isim),
nas.nasname
from nas
left join aboneler on ( aboneler.nas = nas.id )
group by nas.nasname
和
select
count(radacct.radacctid)
from nas
left join radacct on ( radacct.nasipaddress = nas.nasname )
where radacct.acctstoptime is null
group by nas.