标题: 这个整合语句怎么写 [打印本页] 作者: gongyifeng_cs 时间: 2006-10-12 09:34 标题: 这个整合语句怎么写 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
怎么写?作者: Tigersong 时间: 2006-10-12 10:16
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作者: 重剑无锋 时间: 2006-10-21 10:23
不知道你这3个表的主键啊! 是不是都是netnodeno 的唯一? 如果有2个以上的表不是用一个语句就难取了!