I am having difficulty trying to return data in a very compact form. Here is a simple example that will explain the problem:
I have a table with column E, T and P containing data such as A, 1, R A, 1, S A, 2, R A, 2, S Trying the query select E, group_concat(T,';'), group_concat(P,';') give me the expected results A 1;1;2;2 R;S;R;S However, I would like to create a query will return the results A 1;2 R;S Any ideas? Noah Hart -- View this message in context: http://old.nabble.com/how-to-use-group_concat-uniquely-tp30712025p30712025.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
