All, I have a dataset that looks like this:
rowid ; fieldA ; fieldB 1 ; val1 ; This is a 2 ; val1 ; small 3 ; val1 ; test. 4 ; val2 ; The proof is in 5 ; val2 ; the pudding. And I would like to merge all values in fieldB when the value in fieldA is the same. rowid ; fieldA ; fieldB 1 ; val1 ; This is a small test. 2 ; val2 ; The proof is in the pudding. Question: can you do this with an SQL query? thanks for your help. Gert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users