Thank you Igor, that's exactly what I need. Pete Haworth
On Nov 10, 2009, at 4:00 AM, sqlite-users-requ...@sqlite.org wrote: > You are looking for group_concat (http://sqlite.org/ > lang_aggfunc.html): > > select KeyA, DataA, group_concat(DataB) > from TABLEA join TABLEB on TABLEA.TableBKey=TableB.KeyB > group by KeyA; > > Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users