select netnodeno,count(merchno) as merchcount
from netnodeinfo_pos group by netnodenoselect netnodeno,count(phoneid) as pidcount
from netnodeinfo_pid group by netnodenoselect netnodeno,count(date) from netnodeinfo_jrn as jrncount
from netnodeinfo_jrn group by netnodeno select netnodeno,sum(convert(numeric(16),amt)) as atmcount
from netnodeinfo_jrn group by netnodeno select netnodeno,sum(convert(numeric(16),kickback)) as kickbackcount
from netnodeinfo_jrn group by netnodeno 这5个语句将他们和起来,组成一个表
netnodeno,merchcount,pidcount,jrncount,atmcount, kickbackcount
from netnodeinfo_pos group by netnodenoselect netnodeno,count(phoneid) as pidcount
from netnodeinfo_pid group by netnodenoselect netnodeno,count(date) from netnodeinfo_jrn as jrncount
from netnodeinfo_jrn group by netnodeno select netnodeno,sum(convert(numeric(16),amt)) as atmcount
from netnodeinfo_jrn group by netnodeno select netnodeno,sum(convert(numeric(16),kickback)) as kickbackcount
from netnodeinfo_jrn group by netnodeno 这5个语句将他们和起来,组成一个表
netnodeno,merchcount,pidcount,jrncount,atmcount, kickbackcount
select netnodeno,count(merchno) as merchcount into #t1
from netnodeinfo_pos group by netnodenoselect netnodeno,count(phoneid) as pidcount into #t2
from netnodeinfo_pid group by netnodenoselect netnodeno,count(date) from netnodeinfo_jrn as jrncount into #t3
from netnodeinfo_jrn group by netnodeno select netnodeno,sum(convert(numeric(16),amt)) as atmcount into #t4
from netnodeinfo_jrn group by netnodeno select netnodeno,sum(convert(numeric(16),kickback)) as kickbackcount into #5
from netnodeinfo_jrn group by netnodeno select a.netnodeno,a.merchcount,b.pidcount,c.jrncount,d.atmcount, e.kickbackcount from #t1 a
left join #t2 b on a.netnodeno=b.netnodeno
left join #t3 c on a.netnodeno=c.netnodeno
left join #t4 d on a.netnodeno=d.netnodeno
left join #t5 e on a.netnodeno=e.netnodeno
from netnodeinfo_pos ,
(select netnodeno,count(phoneid) as pidcount
from netnodeinfo_pidgroup by netnodeno)t1,
(select netnodeno,count(date) from netnodeinfo_jrn as jrncount
from netnodeinfo_jrn group by netnodeno )t2,
(select netnodeno,sum(convert(numeric(16),amt)) as atmcount
from netnodeinfo_jrn group by netnodeno )t3,
(select netnodeno,sum(convert(numeric(16),kickback)) as kickbackcount
from netnodeinfo_jrn group by netnodeno )t4
where netnodeinfo_pos.netnodeno=t1.netnodeno and
netnodeinfo_pos.netnodeno=t2.netnodeno and
netnodeinfo_pos.netnodeno=t3.netnodeno and
netnodeinfo_pos.netnodeno=t4.netnodeno
group by netnodeinfo_pos.netnodeno