请教 双表查询

[zlj113]

有个问题请教大家.当我有第一个表有number字段,su字段,第二个表有number,tm,ds字段.第一个表里的值4条记录.
1,10,
2,20,
1,150
2,24
第二个表里有二条记录
1,34,35
2,65,24
现在我要用到多表查询.也就是用第二个表,所先用分类汇总求出number的su的总和.然后和第二个表去关联.用a.number=b.number 这样行吗

[zlj113]

就是说把第一个表的两条记录和并,做成二条记录.第一条 1,160
第二条为2,44.
然后和第二个表里面用第一个字段和第二个表里的第一个字段去关联.最后结果为1,160,34,35
第二条为 2,44,65, 24

[yesterday2000]

slect a.number,sum(su) as su,b.tm,b.ds
from tablenma a,tablenam b
where a.number=b.number
group by a.number,b.tm,b.ds

[victorycyz]

select b.number,isnull(sum(su),0),tm,ds
from table1 a right join table2 b on a.number=b.number
group by b.number,tm,ds

[skingddddd]

select b.number,b.tm,b.ds,c.su
from b,
(select a.number,sum(a.su) su
from a
group by a.number ) c
where a.number = c.number ;

[pzr]

select b.number,c.sub,b.tm,b.ds,
from b,join(select a.number,sum(a.su) sub
from a
group by a.number ) c on a.number = c.number ;