Re: Carry out SUM and place result into a different table

[Peter Brawley]

On the Select query ...

select a,b,c,sum(e),sum(f),sum(g)
...
group by a ...

... will give arbitrary results for b and c, you need ...

group by a,b,c ...

To update a second table, you'll need a primary key value for that table unambiguously identifying which row to update, then you can write something like ...

update sumtbl a
join ( the above query ) b on ...
where ...