大家帮我看看这条SQL语句怎么写？

[cmt123]

table1 结构：a1,a2,a3,Amount1,Time
table2结构：b1,b2,b3,Amount2
以字段b1,b2,b3分组统计字段Amount2 插入table1表对应的字段a1,a2,a3,Amount1.在同一行把系统时间插入Time字段.请问这条SQL语句怎么写为好！

[pengdali]

insert table1 (a1,a2,a3,Amount1,Time) select sum(b1),sum(b2),sum(b3),Amount2,getdate() from table2 group by Amount2

[happydreamer]

insert table1 (a1,a2,a3,Amount1,Time)
select a1,a2,a3,sum(amount)
from table2
group by a1,a2,a3

[triout]

Insert Into Table1 (a1,a2,a3,amount1,time)
select b1,b2,b3,sum(amount2) as amount1,getdate() as time from table2 group by b1,b2,b3

如果你要不数据累加到TABLE1中则：
Update Table1 Set table1.Amount1=table1.Amount1+b.amount2,table1.time=getdate()
from (select b1,b2,b3,sum(amount2) as amount2 from table2 group by b1,b2,b3) b
where table1.a1=b.b1 ans table1.a2=b.b2 and table1.a3=b.b3

[joygxd]

insert into table1(a1,a2,a3,amount1,time)
select b1,b2,b3,sum(amount2) ,getdate() from table2 group by b1,b2,b3

[yoki]

insert into table1(a1,a2,a3,amount1,time)
select b1,b2,b3,sum(amount2) ,getdate()
from table2
group by b1,b2,b3