00:38:10 +0200
> Subject: Re: [sqlite] Can this be done in SQLite?
>
>
>
> On 2015-10-09 12:22 AM, K. P. wrote:
> > I tried this, of course, before asking, but:
> > group_concat(distinct(t.LastName || ', ' || t.FirstName), '; ') As Teachers,
> > gives
>
; From: rsmith at rsweb.co.za
> Date: Thu, 8 Oct 2015 23:58:09 +0200
> Subject: Re: [sqlite] Can this be done in SQLite?
>
>
>
> On 2015-10-08 11:47 PM, K. P. wrote:
> > Am using SQLiteStudio - which I really like - though I have wondered if it
> > passes all its k
?
> To: sqlite-users at mailinglists.sqlite.org
> From: rsmith at rsweb.co.za
> Date: Thu, 8 Oct 2015 23:34:05 +0200
> Subject: Re: [sqlite] Can this be done in SQLite?
>
>
>
> On 2015-10-08 11:30 PM, K. P. wrote:
> > It does indeed work - had to make myself a simpler query than
ne in SQLite?
>
>
>
> On 2015-10-08 11:30 PM, K. P. wrote:
> > It does indeed work - had to make myself a simpler query than the real life
> > one to see this. I probably had some other syntax error that I mistook for
> > it...
> > Thanks!
>
&g
Subject: Re: [sqlite] Can this be done in SQLite?
>
>
>
> On 2015-10-08 10:54 PM, K. P. wrote:
> > Thanks for that.I'd need something along the lines of
> >
> > group_concat(c.LastName || ', ' || c.FirstName, ';') as ClientName,
> >
> >
> > wh
way around this?
> From: slavins at bigfraud.org
> Date: Thu, 8 Oct 2015 17:01:06 +0100
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Can this be done in SQLite?
>
>
> On 8 Oct 2015, at 4:59pm, K. P. wrote:
>
> > Given the following tab
Given the following tables, is it possible to extract rows of class data along
with all participating student names concatenated in one column in a single SQL
query?
Classes---IDDateSubject
ParticipantsIDClassIDStudentID
StudentsIDName
As always, thanks for
7 matches
Mail list logo