subject:"\[sqlite\] Multiple joined values in one row"

Re: [sqlite] Multiple joined values in one row

2009-11-09 Thread Igor Tandetnik

Peter Haworth wrote: > Given the following tables: > > TABLEA > KeyA, > DataA > TableBKey > > TABLEB > KeyB > DataB > > .. and a JOIN on TABLEA.TableBKey=TableB.KeyB > > IS there a SELECT statement that returns TABLEA.KeyA, > TABLEA.Data,AllDataB, where AllDataB consists of all the values of

[sqlite] Multiple joined values in one row

2009-11-09 Thread Peter Haworth

Given the following tables: TABLEA KeyA, DataA TableBKey TABLEB KeyB DataB .. and a JOIN on TABLEA.TableBKey=TableB.KeyB IS there a SELECT statement that returns TABLEA.KeyA, TABLEA.Data,AllDataB, where AllDataB consists of all the values of TableB.DataB strung together? For example, for T