51,396
社区成员




select titemname,count(tmax_num)as mnum,count(treal_num)as rnm
from state join csiscode cc on cc.tcode=tduty and cc.tcodetype='80'
where tduty!='' group by tduty, cc.titemname order by tduty
select cc.titemname,count(State.tmax_num)as mnum,count(State.treal_num)as rnm
from State , csiscode cc where cc.tcode=tduty and cc.tcodetype='80' and
tduty!='' group by tduty, cc.titemname order by tduty
select cc.titemname,count(State.tmax_num)as mnum,count(State.treal_num)as rnm
from State , csiscode cc where cc.tcode=tduty and cc.tcodetype='80' and
tduty!='' group by tduty, cc.titemname order by tduty
select cc.titemname,count(State.tmax_num)as mnum,count(State.treal_num)as rnm
from State , Csiscode cc where cc.tcode=tduty and cc.tcodetype='80' and
tduty!='' group by State.tduty, cc.titemname order by State.tduty
select titemname,count(tmax_num)as mnum,count(treal_num)as rnm
from state , csiscode cc where cc.tcode=tduty and cc.tcodetype='80' and
tduty!='' group by tduty, cc.titemname order by tduty