Help taking data from 1 table to another.

[Mark_Nordstrom]

Ok. Attached is the table structure i use. When stuff is submitted it creates a new row even if the person has the same name.

I wanna sum all the data from this table and put it in a different table where each name has 1 row but it has all the data that was summed from other table.

The table names are

stats and
fullstats

the stats is where im getting data from.

[barand]

a variation on this will help

INSERT INTO fullstats SELECT name, SUM(points) as points, SUM(assists) as assists FROM stats GROUP BY name

If you want to create fullstats

CREATE TABLE fullstats SELECT name, SUM(points) as points, SUM(assists) as assists FROM stats GROUP BY name

hth