表1:
Num Toll
01 50
01 40
02 30
03 10
02 10
表2:
Num Name
01 aaa
02 bbb
03 ccc
我在表1中统计出此代号人员的Toll次数和Toll总和
select Num,count(Num),sum(Toll) from 表1 group by Num
但我需要将表2此代号人员的Name也统计在其中,形如结构:
Num,Name,次数,合计
求一句综合SQL
Num Toll
01 50
01 40
02 30
03 10
02 10
表2:
Num Name
01 aaa
02 bbb
03 ccc
我在表1中统计出此代号人员的Toll次数和Toll总和
select Num,count(Num),sum(Toll) from 表1 group by Num
但我需要将表2此代号人员的Name也统计在其中,形如结构:
Num,Name,次数,合计
求一句综合SQL
from (select Num as Num,count(Num) as Num_Cnt,sum(Toll) as Toll_sum from 表1 group by Num) a, 表2 b
where a.Num=b.Num
from tb1 a,tb2 b
where a.Num=b.Num
group by a.Num,b.Name