这个整合语句怎么写

gongyifeng_cs

select netnodeno,count(merchno) as merchcount
from  netnodeinfo_pos group by netnodeno

select netnodeno,count(phoneid) as pidcount
from netnodeinfo_pid group by netnodeno

select 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

怎么写？

Tigersong

select netnodeno,count(merchno) as merchcount,
count(phoneid) as pidcount,
count(date) from netnodeinfo_jrn as jrncount,
sum(convert(numeric(16),amt)) as atmcount,
sum(convert(numeric(16),kickback)) as kickbackcount,
into table_name
from  netnodeinfo_pos
group by netnodeno

重剑无锋

不知道你这3个表的主键啊! 是不是都是netnodeno 的唯一? 如果有2个以上的表不是用一个语句就难取了!