Hi, I only find row-wise concatenation by not column-wise.
For example, I have table x1 y1 x1 y2 x2 y3 x4 y4 I want to have the second column concatenated based on the value in the first column to get the new table x1 y1y2 x2 y3y4 Moreover, I want to have a spectator (e.g., ',') in the second column. x1 y1,y2 x2 y3,y4 Could you show me if it is possible to do this in sqlite3? -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
