On 10 Dec 2014, at 3:40pm, RSmith <rsm...@rsweb.co.za> wrote: > INSERT INTO s2merged SELECT a, b, sum(theCount) FROM s2 GROUP BY a,b;
Thanks to Martin, Hick and R for this solution. It was just what I was looking for. > Not sure if your theCount field already contains totals or if it just has > 1's... how did duplication happen? The existing rows contain totals. Or maybe I should call them subtotals. The data is being massaged from one format to another. I did a bunch of stuff when it was text files, then imported it into SQLite and did a bunch more on it as rows and columns. Eventually it'll end up in SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users