Hello all; Any help, directions, or thoughts on this is much apprecaited.
Let's say I have the following table: ID Value 1 a 1 a 1 b 2 c 2 a 3 a 3 c 3 b Is there a quick way in SQLite that will let me build a new table so that it is now represented where the ValueCombination is sorted such as: ID ValueCombination 1 a 2 a,c 3 a,b,c After this is done can I build a table from this tabel for the counts associated to the Values in the ValueCombination field such as: Value Count a 3 b 1 c 2 After this I would like to build a table again from the ValueCombination table to count the instances of the ValueCombination such as: ValueCombination Count a 1 a,b,c 1 a,c 1 As mentioned any suggestions are much appreciated. Celeste. -- View this message in context: http://www.nabble.com/Concatenate-multiple-rows-into-a-set-list%28no-duplicates%29-based-on-unique-ID-tp17827185p17827185.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
