insert into table3(id,name,price,unit,sum)
select table1.id ,name,price_product ,unit_product,aa.sum
from table1
left join
( select id,sum(sum_prouct) as sum from table2 group by id) aa
on table1.id=aa.id
select table1.id ,name,price_product ,unit_product,aa.sum
from table1
left join
( select id,sum(sum_prouct) as sum from table2 group by id) aa
on table1.id=aa.id
insert table3(id,name,price,unit,sum)
select a.id ,a.name,a.price_product,a.unit_product,sum(b.sum_product) from table1 a,table2 b where a.id=b.id若存在table1中的id在table2中无对应id记录情况的话:insert table3(id,name,price,unit,sum)
select a.id ,a.name,a.price_product ,a.unit_product,isnull(b.sum,0)
from table1 a
left join ( select id,sum(sum_prouct) as sum from table2 group by id) b
on a.id=b.id