jason h wrote: > > What i'm basically trying to do is to create a new table from the > existing table, with joined rows that have the same recording_id, and > add the quantitys together. The order of the rows isn't important. create your new table... then run this: insert into NEWTABLE ( SELECT `recording_id` , sum( `quantity` ) FROM `OLDTABLE` GROUP BY recording_id ) Note: your mysql version must be up to date to run the inline query like this. The group by on only one field is considered bad practice, so test before you do the actual insert. on my sample table, this worked fine though.