The following example demonstrates what seems to be a bug in group_concat. With the latest version of CVS:
CREATE TABLE example (id INTEGER, x TEXT); CREATE TABLE table2 (key TEXT, x TEXT); CREATE TABLE list (key TEXT, value TEXT); INSERT INTO example VALUES (1, "a"); INSERT INTO table2 VALUES ("a", "alist"); INSERT INTO table2 VALUES ("b", "blist"); INSERT INTO list VALUES ("a", 1); INSERT INTO list VALUES ("a", 2); INSERT INTO list VALUES ("a", 3); INSERT INTO list VALUES ("b", 4); INSERT INTO list VALUES ("b", 5); INSERT INTO list VALUES ("b", 6); SELECT example.id, table2.x, (SELECT group_concat(list.value) FROM list WHERE list.key = table2.key) FROM example, table2; Output: 1|alist|1,2,3 1|blist|,4,5,6 I expected: 1|alist|1,2,3 1|blist|4,5,6 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users