Thank you Igor, that's exactly what I need. Pete Haworth
On Nov 10, 2009, at 4:00 AM, [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
